Manual vs. Automatic Calculation

  • Thread starter Thread starter Lori
  • Start date Start date
L

Lori

We recently upgraded from Office 2000 to 2003. Some users
default settings are to calculate manually vs
Automatically while others default settings are set to
calculate automatically vs. Manually. Anyone know why?
Where can we change this to be one way or the other
globally. (for all workbooks, not just the active one)?
 
Excel picks up this setting from the first workbook it opens in this session.

If you have someone who likes manual calculation and saves the workbook (to a
network location) with it set for manual, then if it's the first workbook opened
by anyone, they'll be changing this setting.

It could be a battle of wills!

So remember how to toggle this setting. (and watch the status bar in the lower
left corner for warnings about Calculation.)
 
Back
Top