calculation of cells

M

mark obershmidt

Periodically I open a work book and the calculation option
has been changed to manual and I cannot figure out why. It
seems that it would have to be done by a user and most of
my spreadsheets are only used by me.

Any ideas out there
 
E

Earl Kiosterud

Mark,

Calculation, auto or manual, is set by the first workbook that's opened. It
is that way for any other workbooks opened in that instance of excel. Look
for a workbook you might have opened first that's been set to Manual and
saved that way. Go figure.
 
R

RagDyer

Check out this old post.

http://tinyurl.com/2hhcn
--

HTH,

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

Periodically I open a work book and the calculation option
has been changed to manual and I cannot figure out why. It
seems that it would have to be done by a user and most of
my spreadsheets are only used by me.

Any ideas out there
 
Top