A little trouble with Excel

[JohnT]

I run Win XP and Office 2003.

I recently had to re-install Office and now when I change the figures in a column the equations do not work until I save it. I like to look at the changes as they happen. Any help please?

I also like to have the last nine sheets that I have been working on to show in the File Menu. It gets up to about three sheets and then they all vanish, most annoying. Any help with that one as well please?

John

[Glenn]

1st Problem: Is Tools > Options > Calculation > Automatic enabled?

 

EDIT:

 

2nd Problem: What is your setting for Tools > Options > General > Recently used file list ?

[JohnT]

Thanks Glenn

1st Problem: The dot was and is in Automatic

I just tried Automatic without tables and it now works OK I changed it back to Automatic and it is still working. I really is a worry.

2nd Problem: The tick is in for Recently used file list and I had raised it to nine.

Oh it's a worry!

John

[Glenn]

For the 2nd Problem, when you said

... It gets up to about three sheets and then they all vanish ...

did you mean the File menu Recent Files field between "Properties" and "Exit" becomes empty? ... or that the whole field is absent (but you can see "Exit")? ... or that you get the abbreviated menu (with the expand button at the bottom)?

[JohnT]

The first problem seems to have solved it's self but the second one is sitting with three lately used files at the bottom of the file menu at this moment. Yes they are between Properties and Exit and I expect them to have vanished again by tomorrow AM. This has been going on for well over a month since I reinstalled Office.

By the way, I see you are from Canada, I move down to NZ from Canada nearly 23 years ago.

Cheers

John