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