View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
qualitywoodworking qualitywoodworking is offline
external usenet poster
 
Posts: 2
Default Workbook Calculations set to Automatic - Excel 2007

Hi... i'm new to this forum and have looked for an answer to my question w/
no luck. I have several work sheets in my workbook that feed into a summary
work sheet. I try setting my workbook calculation to 'Automatic' under
'Excel Options' - 'Formulas', but Excel will not 'Save' this change. Each
time i go back to check it is set to 'Manual'. The only way my formulas
update on each individual work sheet and on my summary worksheet is to hit
F9. Why doesn't it do it automatically?

Thanks for your help.
--
qualitywoodworking