Windows 7 Pro, Office Excel 2013, i7 last generation processor, 8 GB RAM.
I'm working on a project of about 25 MB, a lot of index formulas, tables (not range) and everything is local(the info I use is in the same document).
But I have this only sheet that is slower than the rest (the calculation options are in manual mode always), and in these sheet when I change the number of an specific cell, it freezes for about 40 secs (only if I change the data, not with the calculation), also this cell data is used in only 4 cells of the document in different sheets.
I don't know what is happening because I'm in manual mode with formulas. Also in that same sheet when I try to add new rows, it get stuck too.
I have recently had the same problem and I solved it by copy/paste all my work into a new excel workbook. But after 2 weeks It appeared again.
I also don't have any macro or conditional formatting, the document is on my computer (not a network).
In particular: When I change the data 1 time it freeze, after this if I dont calculate the sheet again, I can change the data freely with no problem. But when I calculate again and then change again the data of the cell it freeze.
Lots of formulas and stuff
- Sigh... If you're not going to be clear then we can't understand ;) . Please explain what isstuff
. Also where is the file saved (locally, network). This is a very strange issue to debug. Please also clarify, is the issue it's slow when you change the data of the cell, or when you perform the calculation? You're best to edit your post with this data so others can read it too :)