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
 
Ron

colleagues(OK) may have some set to manual as you surmise.

Gord
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Calculate 1
Automatic Calculation 2
Spreadsheet won't calculate 3
Calculate message 3
Why does 'calculate' show in the status bar, even after i hit F9? 1
Calculating High and Low 2
Inserting data question 1
Calculate message 1

Back
Top