Excel and calculations
 

By default Excel is set to automatically recalculate formulas. However, users
are finding that the setting is changing to calculate manually (even though
they do not know that the option exists/haven't gone into Tools/Options to
change it). Is there a shortcut key/way this can be triggered accidentally??

Thank you
--
SP

Excel and calculations
 

Hi

When the users opens a workbook, where calculation is set to manual, then
for all other workbooks opened later during the same session, calculation is
set to manual too. (And in case they are saved without changing the
calculation to automatic before, next time calculation is set to manual for
them too)

The only medicine I can think of, is to set calculation to automatic through
VBA in workbooks Open event.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"s page" wrote in message
...
By default Excel is set to automatically recalculate formulas. However,
users
are finding that the setting is changing to calculate manually (even
though
they do not know that the option exists/haven't gone into Tools/Options to
change it). Is there a shortcut key/way this can be triggered
accidentally??

Thank you
--
SP