Modifying data in excel containing 4000+ formulas

S

sona.basu

I have an excel that has more than 4000 formulas and now i cannot
modify data in it. It keeps hanging each time I try to update it.

Does anyone know how this can be dealt with?

Thanks!
 
J

John Michl

With that many formulas, you should turn calculation to Manual.
(Tools > Options > Calculation). Then press F9 anytime that you want
the sheet to recalculate.

- John
 
B

bj

you probably have enough equations to cause excel to recalc every cell when
you change anything.
Beyojd a sectain number of links (I don't remember how many) every cell s
recalculated.
Work arounds
paste special value for calculations not repeated
(I normally set a macro to enter a bunch of equations and then paste the
values back on the cells when I have some calcs which are done very rarely.
split data into seperate workbooks
set calculation to manual and only calculate when all new data has been
entered.

for a limited
 
Top