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!

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!

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!