Results 1 to 3 of 3
  1. #1
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Do you want to save changes? (2000/2002)

    I am the only person on our network with Office XP. If I open a file created in 2000, make no changes, then try and close it, I get a warning message:
    Do you want to save the changes to . . . .xls?
    Microsoft Excel recalculates formulas . . . .
    Some are Read Only, some are shared with other users - so there seems no point in saving them in 2002 - someone else will save at a later date with 2000.
    Is this something I've got to learn to live with?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Do you want to save changes? (2000/2002)

    I have not seen Excel 2002 as yet, but if you goto Tools, Options and select the Transition Tab, you should be able to select the default file format that files are saved as. Hopefully if you set it to XL 2000 that warning should not present.

    Worth a try.

    Andrwe C

  3. #3
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Do you want to save changes? (2000/2002)

    Thanks - but the only 'suitable' option other than 'Microsoft Excel Workbook' is Microsoft Excel 97-2002 & 5.0/95 Workbook - and that seems to make no difference.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •