calculation of cells

[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

 

[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.

 

[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