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.

I have an Excel file which is super slow, like copying a cell to another takes more than a minute which should be done in a second. When I try to copy 10 cells to another area, Excel stops responding. I had the same problem before and deleted old information on the file, previously cached data. It worked and solved my problem but right now funny I just cant find the same option. I would be glad if you can help me!I have Excel 2007.

File size with Excel 2003 : 1,9 MB (Works in compatibility mode, original file, I saved it as 2007 to find a solution)

File size with Excel 2007 : 96,4 KB

Excel is using normally 200-300 KB memory but when I want to make the copy operation I want it climbs up to 1.800 KB and later gives the error MS Office Excel encountered a problem and need to close, Debug, send error report etc.

There is no formula and external data, my computer is also new. I would like to find the option again to delete the old data or cache, cant remember exactly now but if I remembered I wouldn't ask the question.

The computer has no problem, everybody is having the same problem with this excel file, all other excel files are working fine and fast on my computer.This file is a list of products and every week it is updated/overwritten.The file is on my local computer.

OS: Win 7 64bit

share|improve this question
    
This on a 32-bit operating system? –  Ramhound Sep 10 '13 at 15:38
    
@Ramhound win7 64bit –  Anarkie Sep 10 '13 at 15:48
    
There's nothing like "clear file cache" in Excel that I'm aware of. Is it only this specific file, or are others operating the same way? Does closing and reopening Excel help any? Anyone else have this problem with that file? Is the Excel file local or on a remote server? Since you say the computer is new, have you checked the disk drive(s) to confirm they are operating up-to-snuff and didn't come from the factory with a problem? Have you checked over Excel sheet becomes very slow yet? –  techie007 Sep 10 '13 at 15:49
    
@techie007 The computer has no problem, everybody is having the same problem with this excel file, all other excel files are working fine and fast on my computer.This file is a list of products and every week it is updated/overwritten. –  Anarkie Sep 10 '13 at 15:55
    
Is the Excel file local or on a remote server? Like, are all these users using the same copy of the file (say, via a share)? –  techie007 Sep 10 '13 at 16:07
show 8 more comments

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.