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

  • Thread starter Thread starter TMangino
  • Start date Start date
T

TMangino

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date recalculates 1
Charts Constantly Recalculating 10
Multiple Instances of Excel on 64-bit Win7 1
Excel 2007 recalculates Excel 2003 spreadsheet upon opening 1
Formulas Not Recalculating Automatically 1
Automatic recalculation of array functions 5
recalculate page breaks after setting Zoom in pagesetup 3
Where does Ms XL store the clipboard ? or where does MS Windowsstore clipboard ? 1

Back
Top