Suppressing the Recalculation of formulas from pre-2003 versions of xl

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TMangino@gmail.com - 12 Oct 2006 00:45 GMT

Any way to do this? I found some old reg key fixes that don't seem to
work on 2003. Any help is greatly appreciated

Reply to this Message

Pete_UK - 12 Oct 2006 01:53 GMT

I don't know if this is what you want, but if you start Excel and go to
Tools | Options | Calculation (tab) you can set it to Manual, before
opening any files. Now any files that you do open will be in manual
calculation mode - you can get them to recalculate by pressing F9. If
you save the file, then a full recalculation is normally done (unless
you unchecked this in Tools | Options).

Hope this helps.

Pete

> Any way to do this? I found some old reg key fixes that don't seem to
> work on 2003. Any help is greatly appreciated

Reply to this Message