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!