I have had a frequent problem in Excel 2013 and Excel 2010 on several different computers, where Excel would freeze for 10-20 seconds when I copied a few cells into 3 or more locations.   I frequently want to copy data into every other row, so I end up hitting paste repeatedly on the same set of copied data, until Excel freezes and I have to wait for it.  I'm hoping someone else has encountered this same problem and has a workaround or solution for this, as when I have to fill in a hundred columns of data this really slows me down.  I've had this problem on three different computers, in both Office Excel 2013 and Office Excel 2010, so it doesn't seem specific to any particular computer setup.   I've attached an example where Excel froze during a copy, and a list of my addins installed.
123932
When cutting/copying some cells to paste them into another sheet/page, sometimes Excel freezes/locks up and fades out. At the top toolbar it says in brackets "not responding".  Eventually, I must click 'X' to close the program. It offers to wait for the program to respond, but never does – it just does nothing until I finally close it, where it offers to recover files etc.   Is there an issue with memory here? What can I do to stop it locking up?
58187
I have a 20,000 line spreadsheet in Apple Numbers, and I need to fill a column with data. I don't want to sit there dragging down the fill handle for thousands of rows.   How can I fill the whole column with a value?
6497
I noticed that if I transfer a few large files between two hard drives, it's pretty speedy, at around at least 30&nbsp;MB per second, but if I transfer thousands of files less than 5&nbsp;KB, it is pretty damn too slow.. around 1 to 2&nbsp;MB per second.   Is there a way to speed up the copy/paste process with thousands of small files on Windows 7?
43013
I have the following formula in a sheet:  =if(E1="HOLD",,query(Cust_Orders!B6:Z5000,"Select Y,G,I,H,K where H&gt;0  "))   With E1 being a drop down with values HOLD and FETCH  The recalculation when I go to FETCH takes about 13 seconds.  But when it is in HOLD, the query doesn't exceute, and everything goes blank. Not what I want.  I'm trying to avoid recalculating this query every time I make a change in the Cust_Orders range, but keep the old values, as two different pivot tables that are viewed by other people are dependent on it.  Google spreadsheet recalc settings all are 'on change and foo'  Is there a way to do this?
29070
I have a similar problem to what is mentioned in . But to make things a little more difficult, the table has approximately 1000 rows and 64 columns. I thought of splitting up the table but the users insist on viewing all the columns at once. Hence I have come up with one option where the first two to three columns with name, ID are set to a freeze state (like in excel) and rest of the columns scroll under these columns; i.e. the table gets a horizontal scroll and to solve the row issue i have given a pagination. I have recommended that the table will be displayed only if there are 100 rows, if there are more than 100 rows the user will get an export to excel/import from excel option.  Is there a better way to handle this?
83158
I'm using Microsoft Word 2010 and I worked in a word-2003 compatible document (.doc). After hours of working, I selected a half of text and did Ctrl+X to copy it into another document. Surprising, after closing the current document and opening a new one and pressing Ctrl+V, nothing happened. After closing original document, ms word asked me if I want to save the clipboard buffer and I pressed No, as I didn't knew that MS Word has it's own clipboard.  Is there a way to recover that text that was "cutten" from original document and never "pasted" to the new one? The PC was not rebooted so i guess all my temp files are here.
19032
I have data in a Word table that includes line and paragraph breaks. When I copy the data into Excel, it splits each line and paragraph I want into multiple cells. How do I copy the data to Excel and keep the breaks?
27588
Repeated error  I have been repeatedly encountering the following error when my laptop freezes. It may occur multiple times during the day, and should take several minutes to recover.  Source Windows  Summary Hardware error  Date ‎11/‎1/‎2018 10:11 AM  Status Not reported  Description A problem with your hardware caused Windows to stop working correctly.  Problem signature Problem Event Name: LiveKernelEvent Code:   144 Parameter 1:    3003 Parameter 2:    ffffad8c0b1a75c8 Parameter 3:    40010002 Parameter 4:    0 OS version: 10_0_17134 Service Pack:   0_0 Product:    256_1 OS Version: 10.0.17134.2.0.0.256.48 Locale ID:  1033   More details  Per my best reflection, the hardware error occurs when I am using the laptop on its docking station. Here is what I observe:   While using the laptop as normal, the "freeze" will occur and I can hardly operate the laptop: mouse cursor won't move continuously and Alt+Tab won't be able to switch across two windows. Shortly after (usually several minutes), things will go back to normal. Upon inspecting through the Performance tab in Task Manager, there had been no spike in anything, be it CPU, Memory or Disk. When I open the View reliability history tool, I will find another entry of Windows Hardware Error   Machine specification:   Thinkpad T480, i7-8650U (newly replaced module thanks to the manufacture)   With the same pair of docking stations, an older unit of T480 has had exactly the same problem.  Docking station: . Same issue has occurred on two identical docks with  slightly different monitors and accessories. OS specification: OS build 17134.376. Most recent collection of "reliability report":    Possible solutions   First, I would like to learn what exactly went wrong, hardware-wise: the manufacturer's support team did not bother too much with the precise error messages, and have ordered me to reinstall the Windows OS up to 5 times in total. [This is what they called "debugging".]   Please advise if you can decipher the recurrent "Hardware error".   Secondly, I will try to push the manufacturer to replace the docking stations, and see if the same "freezing problem' persists.
36675
I am trying to create a new instance of Excel using VBA using:  Set XlApp = New Excel.Application   The problem is that this new instance of Excel doesn't load all the addins that load when I open Excel normally...Is there anything in the Excel Application object for loading in all the user-specified addins?  I'm not trying to load a specific add-in, but rather make the new Excel application behave as though the user opened it themself, so I'm really looking for a list of all the user-selected add-ins that usually load when opening Excel.
123970
I use a Windows 10 machine remotely at work. Both the local and remote machine are in the same ISP network (not same local network, but same ISP). I've been using it like that for almost a year now and I had never experienced absolutely any issues.  Until recently. I don't know if anything specific triggered this behavior, but I feel that it started happening after I upgraded the remote to W10 1903. I later upgraded the local one as well and I feel that it only made the problem worse (but I don't really have any data).  From time to time, the session will freeze - the image stops updating. However, what I type and mouse clicks are still being sent. No error message is shown whatsoever, the image simply freezes. To make it work again, I have to close and re-open the session. Everything that I had typed and/or clicked while it was frozen is there.  Is there any way I can debug this?
42644
I have more than 10,000 rows of data I need to do some calculations on one column of the data. I have made the calculation in one cell and now need to fill the formula for the calculation and all the cells.  Usually I just select the cells using the keyboard and then press the Ctrl+D to fill the cells. However, now I have to do this repeatedly, and it is difficult to keep on selecting 5000 rows each file. Is there a simpler way where I can just specify the range using the keyboard? Perhaps even have a macro since all of the files have a fixed length  Also, since I have difficulty in using the mouse because of medical reasons and therefore I have not tested  which involves clicking on a very small fill handle. Maybe there is a parallel solution to this using the keyboard or maybe I can create a macro which will automatically click on a fill handle of a selected cell - please advise if there is a way.
13246
I have the task of creating a simple Excel sheet that takes an unspecified number of rows in Column A like this:  1234 123461 123151 11321   And make them into a comma-separated list in another cell that the user can easily copy and paste into another program like so:  1234,123461,123151,11321   What is the easiest way to do this?
1694
I have a formula in a cell which counts the values in 2 other cells. Normally, after entering in the values in these 2 other cells, the formula cell updates automatically when Enter is pressed or when the cells are clicked out of.  However, for some reason, the value calculated by the formula does not update automatically. I am having to click on the formula bar, then I have to click enter for the formula cell to do its thing.  Why is this happening?
50706
I am trying to make a table with 10 columns.  For some reason, when I add an 11th column, the table no longer compiles.    Below is, I believe, a minimum working example.  Specifically, the table works with    \begin{tabular}{l*9{c}}   but it does not work with   \begin{tabular}{l*10{c}}   Note that the following ONLY compiles because it is the version with the 9 rather than the 10.  I would like for it to have the 10 so I can insert an extra column.  My tables begin as:  \documentclass{article} \usepackage{array} \begin{document}  \begin{tabular}{l*10{c}}  &amp; (1) &amp; (2) &amp; (3) &amp; (4) &amp; (5) &amp; (6) &amp; (7) &amp; (8) &amp; (9) &amp; (10) \\   \end{tabular}  \end{document}
18812
I have a large Excel spreadsheet that contains lots of numeric data that I would like to import to ArcGIS 10.2 as a table using the  tool.   The frustrating thing is that the numeric fields in Excel are repeatedly not recognised and are assumed as being text. I have set the cell format to numeric, cleared any possible blank cells, tried importing as CSV, removed invalid characters in the field headers. yet any possible iota of success evades me.  Does anyone know why this may be happening and/or how it can be resolved?
120025
I like to avoid using my mouse as much as possible, but on occasions when I need to type directly into the formula bar I am currently forced to 'rattle the rodent'.  Does anyone know a way to move focus from the worksheet cells into the formula bar with a keystroke combination?
47571
How do I automatically average the lowest 3 of the last 6 numbers in a row of 22 that adds one number per week?  Obviously I need at least 7 numbers to begin using this formula.  Also, some cells in some rows may be blank.