Thread: Values in spreadsheets do not update
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default Values in spreadsheets do not update
ToolsOptions, Calculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sandy at the Chrome" <Sandy at the wrote in message
...
| When I change or enter values in Excel spreadsheets it does not automaticaly
| compute totals, I have to hit the save button for the spreadsheet to update
| the data.


Reply With QuoteReply With Quote