Modifying data in excel containing 4000+ formulas
 

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!

Modifying data in excel containing 4000+ formulas
 

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


On Mar 16, 7:56 am, wrote:
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!

Modifying data in excel containing 4000+ formulas
 

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

" wrote:

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!