View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default how do I stop excel from recalculating sheet every time I open one

EXCEL 2007

Office Button (top left hand corner)

Excel Options (lower right hand corner)

Formulas (on the left hand side) then, on the right hand side, in:-

Calculation options

- switch the Workbook Calculation to Manual then hit OK.

If my comments have helped please hit Yes.

Thanks.

Formulas (on left hand side) / then, on the



"seeing green" wrote:

Every time I open a spreadsheet it recalculates formulas so that means even
if I open one up to look at I now cant just x it out i have to say save, dont
save etc - another annoying step when I am in a hurry