Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2004
    Location
    Sacramento, California, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Opening Same file multiple times (Excel 2000)

    When I open a file (say Test.xls), and then close the file and reopen it, it opens as 'Test1.xls', then, when I close it and open it again, it is 'Test2.xls'. Is there a setting that I can stop this from occurring?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Opening Same file multiple times (Excel 2000)

    Not sure what would cause this. Perhaps "New" has become the default action for .xls files; if so, you can restore normal behavior as follows:

    Activate Windows Explorer.
    Select Tools | Folder Options...
    Activate the File Types tab.
    Select the XLS (Microsoft Excel Worksheet) file type.
    Click Edit... (or Advanced... if you're using Windows XP).
    Select Open in the list.
    Click the Default button to make Open the default action for .xls files instead of New.
    Click OK until you're back in Explorer.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Opening Same file multiple times (Excel 2000)

    Just to cover all angles here...
    Are you sure its not a .xlt file. If you save a template, and then open it and close it, it will add the suffix count after its name. ie. If you save it as Test.xlt, then close it and open/close multiple times it will rename as Test1.xls, Test2.xls ....
    Regards,
    Rudi

Posting Permissions

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