Jump to content


A little trouble with Excel


4 replies to this topic

#1 OFFLINE   JohnT

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 31 August 2007 - 11:03 PM

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

#2 OFFLINE   Glenn

    Power Member

  • Members
  • PipPipPipPip
  • 793 posts
  • Location:Canada

Posted 31 August 2007 - 11:57 PM

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

EDIT:

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

#3 OFFLINE   JohnT

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 01 September 2007 - 05:07 AM

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

#4 OFFLINE   Glenn

    Power Member

  • Members
  • PipPipPipPip
  • 793 posts
  • Location:Canada

Posted 01 September 2007 - 09:59 PM

For the 2nd Problem, when you said

Quote

... 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)?

#5 OFFLINE   JohnT

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 02 September 2007 - 03:51 AM

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