Thread: Why do Excel cells not calculate until I hit "save"
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Why do Excel cells not calculate until I hit "save"
Or in excel 2007

Office Button - Excel options - Formulas
Select automatic

Mike

"Bill R" wrote:

I have a worksheet that performs some simple calculations depending on my
entries in certain cells. Recently I have noticed that the calculations don't
actually take place until I 'save' the spreadsheet. This has just started
happening.
Reply With QuoteReply With Quote