Auto Calculation Keeps Turning Off

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

One of my users (Office XP Pro on Windows XP Pro), has found that the
automatic calculation option keeps turning itself off in their spreadsheets.

They can turn it back on by going into options, but this is obviously
annoying for them.

Their machine has recently been formatted for another reason, and this has
not solved the problem.

The only thing I have yet to do is install Office XP SP3.

Has anyone seen this before?
 
Tools->Option->Calculate
check "Auto Calculate"
--
=====================================================
* ÔÚÎÒÇà´ºÄêÉÙµÄʱºò£¬ÓиöÅ®º¢Ô¸ÎªÎÒÈ¥ËÀ¡£ ¡¡¡¡ *
* ËýÒâÖ¾¼á¶¨µØ¶ÔÎÒ˵£¬ÄãÒªÊÇÔÙ²ø×ÅÎÒ£¬ÎÒ¾ÍÈ¥ËÀ£¡ *
* ÔÚÎÒÇîÀ§Áʵ¹µÄʱºò£¬ÓиöÅ®ÈËÔ¸ºÍÎÒ¹²¸°»ÆȪ£¡¡¡¡¡ *
* ËýÕ¶¶¤½ØÌúµÄ¶ÔÎÒ˵£¬ÄãÔÙ²»»¹Ç®£¬ÎҾͺÍÄãͬ¹éÓÚ¾¡£¡*
* *
* ÕŽ¨Æ½ *
=====================================================
 
Keith

Whether calculation is set to manual or auto is determined by the first
sheet that is opened within Excel. Maybe the user has a sheet that is set to
manual and always opens that first.

Andy.
 
And if it gets turned off while he's in excel, then I'd ask if he runs any
macros.

If he does, then I'd take a look a the code.

A lot of people improve the macro speed by turning calculation to manual. Then
do their stuff. Then turn it back to the way it was (usually automatic).

If the code was interrupted, maybe the setting didn't get toggled back.

(Or maybe something is happening that was unforeseen by the developer--but quite
usual for the user.)
 
This is puzzling.

Some of the spreadsheets have macros, not all, and the code does not turn
calculation to manual.

Also, this is a clean install as the machine was formatted only a couple of
weeks ago. All I need to do is SP3 Office which I will perform today
hopefully.

The user turns calculation back to automatic, but it just turns itself back
to manual as and when it feels like it - it doesn't seem to be related to a
specific spreadsheet or action.
 
There can be code that runs and toggles the calculation mode without the user
explicitly running anything.

If that user starts in Safe mode (disabling lots of things--including macros),
does the calculation method get switched?
 
Back
Top