Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
    
How much data are you working with when this happens? Does it happen when you copy a small amount or a large amount or both? What sort of data are you copying? Only values or also formulas? Have you tried copying something that froze before piece-meal to see if it freezes in smaller chunks? How often does this happen? –  Raystafarian Mar 5 '12 at 12:08
    
@barry which windows system is it? –  Psycogeek Mar 5 '12 at 12:43
    
lot to say.. im running windows 7.... it happens generally with larger rather than smaller volumes.... sometimes with formulas sometimes without....and it happens a lot?? –  Barry Mar 5 '12 at 15:54
add comment

4 Answers

I do not recall this exact problem but I have had similar problems on a number of occasions. Like you I had to abort Excel to clear the problem and it told several such failures before I identified the cause.

The cause was Excel waiting on a question about the operation I had requested which was hidden behind the main Window. I have since discovered that getting that hidden question to display can be difficult but is possible. I do not know why, on rare occasions, the question is not on top as it usually is.

Try looking for a hidden question next time this happens.

share|improve this answer
    
Thanks.. but where to look for 'hidden question'?? –  Barry Mar 5 '12 at 11:54
    
I have not had this problem for a while and do not remember the details. You could try minaturising Excel but I doubt that would work because of the outstanding question. My recollection is that I would click "Show Desktop" which minaturised everything even if there was an outstanding question. Then, when I maximize Excel, the question would be displayed on top. Sorry, this is not more helpful but the true answer is that I clicked things until something happened. –  Tony Dallimore Mar 5 '12 at 12:16
    
Thanks again ;-) –  Barry Mar 5 '12 at 12:31
    
are there any macros in the sheet? Calculation is manual or automatic? –  datatoo Mar 8 '12 at 23:50
add comment

The easier way to display the background running question if it is a response/question popup is to right-click mouse at a clear section in the task bar and select Tile windows vertically rather than selecting Show Desktop to show all active windows.

share|improve this answer
add comment

I have a spreadsheet of Corn prices that covers 20 years - 1000 worksheets. I also have some worksheets at the end showing the results (graphs, etc.) of various scenarios. From time to time I try different things and re-use existing columns on the price worksheets. All of a sudden when I hit ctrl+C (copy) it froze and I got a 'not responding'.

One of two things fixed it. I got rid of some of the summary worksheets - now if works. Either: I had hit some Excel limit as far as what it could handle but I don't think that is likely. What is more likely is my new use of one of the existing columns was an 'IF/THEN' code that returned a text answer rather than a numerical answer. I believe the freezing was due to one of the existing summary sheet items (graphs, etc.) expecting a number field and finding a text field.

share|improve this answer
add comment

Go to File \ Options. Select the "Advanced" tab. Go to the "Cut, copy, and paste" section. Uncheck "Show Paste Options button when content is pasted" and "Show Insert Options buttons"

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.