Auto Calculation

  • Thread starter Thread starter Mahprr
  • Start date Start date
M

Mahprr

We use Excel 2003 a lot on our server. Recently we have started to find
speadsheets with auto calcualtion switched to manual. My questions are
how can this option be switched on i.e. does it come from a template.
Is there an easy way to find all occurrances of spreadsheets with this
indicator swtched to manual. Finally, anyway of overriding the manual
indicator so that automatic calculation so it is always switched on...

many thanks for your assistance with this...

Peter
 
Does this help?

http://tinyurl.com/anahg
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

message
We use Excel 2003 a lot on our server. Recently we have started to find
speadsheets with auto calcualtion switched to manual. My questions are
how can this option be switched on i.e. does it come from a template.
Is there an easy way to find all occurrances of spreadsheets with this
indicator swtched to manual. Finally, anyway of overriding the manual
indicator so that automatic calculation so it is always switched on...

many thanks for your assistance with this...

Peter
 
Thanks that was useful, but still does not address my question of a
easy way of tracking down spread sheets with the calculation set to
manual. Because I know this issue will keep coming back to haunt me.

regards
Peter
 
Perhaps you didn't fully grasp the idea behind the final sentence.

Simply open a *known* auto calc sheet *first*, at the beginning of each
session.
Eventually, all your current WBs should become "auto".
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

message
Thanks that was useful, but still does not address my question of a
easy way of tracking down spread sheets with the calculation set to
manual. Because I know this issue will keep coming back to haunt me.

regards
Peter
 
I hear what you say but I have 50+ users to control they can get the
spreadsheets from server, email, harddrive basically anywhere. nsuring
they startup with a autocalc set to yes on each session is pretty hard.
Any ideas on how to control initial opening of excel would certainly
help...

regards
Peter
 
Back
Top