Auto-Calculate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that utilize the stock quote add-in from MSN. On a daily basis I refresh the add-in functions for the Highs, Lows, Last, Volume, etc. On occasion the spreadsheet reverts to manual caculation settings, and I have to press the F9 even after I updated the quotes. I've always preferred the any spreadsheets I open, blank or otherwise, the automatic setting selected for calculations. I consider this an annoyance. Has anyone experienced this glitch? Is there a fix for it?

Ron_D
 
Ron

Excel takes the calculation mode from the first workbook that opens in a
session.

Subsequent workbooks opened in that session will take that mode no matter
which mode they were saved under.

The only workaround is to make sure you do not open first any book with calc
mode at "Manual" or have workbook_open code in your Personal.xls that sets the
calc mode to "Automatic" when opening.

Gord Dibben Excel MVP
 
Back
Top