Auto calc sets to manual calc

[kyoung]

Has anyone seen this before. I'm using Excel 2002 in XP Pro and when I load files, Excel will decide to take off the auto calc and switch it to manual. In all the versions I've used, I have NEVER had it do this to me before. Can I force it to stay on auto calc somewhere or is it doing that because of memory limitations?

Also, anyone ever had the problem of linking to another spreadsheet, you know it is linked correctly, but the cell doesn't have the correct number? I have found that doing update link doesn't work, BUT if I hit F2 and enter as if I'm going to edit the cell, the correct number comes through.

Hope this makes sense. Any thoughts or help would be appreciated greatly.

 

[Von Pookie]

Excel changes the mode of calculation so that whatever files are open all use the same mode.

http://support.microsoft.com/default.aspx?scid=kb;en-us;214395&Product=xl2002

 

[Travis]

Also, anyone ever had the problem of linking to another spreadsheet, you know it is linked correctly, but the cell doesn't have the correct number? I have found that doing update link doesn't work, BUT if I hit F2 and enter as if I'm going to edit the cell, the correct number comes through.

Does F9 also work? If so, its becasue of your manual calc problem.

 

[kyoung]

Travis - F9 doesn't do it either. I have to do F2 then enter. It is really interesting cause I have NEVER seen this before. It has happened to someone else at my office also, so I know I'm not crazy. I'm just wondering if this is a bug in excel that hasn't been realized yet. It isn't all the time either...I don't know, maybe I am crazy.

Von Pookie - my only problem with what you said is that there will be times when haven't opened any files, just doing a lot of manipulation and it gets "tired" Like I said, I'm wondering if it is a memory constraint in that it's trying to conserve it by not calculating all the time. It's more annoying than anything.

Thanks for the replies