Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Opening Excel File (Excel XP)

    I'm having errors when I open the attached file in Excel. I receive the file via email and when I opens it, it gives an error on the sheetname. How can I get past it. Unfortunately I can't change the format of the file since it is run on a application which I don't have access to, so I need to do something in Excel XP in order to avoid the error. Strangely enough the error doesn't happen in Excel 2000

    Thanks

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Opening Excel File (Excel XP)

    Hi,
    Do you know what the original sheet name was? (when I open that in XP it automatically "fixes" the sheet name, correcting it to Recovered_Sheet1) It would appear that XP regards it as an invalid name.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Excel File (Excel XP)

    I've opened the file in Excel 2000 and the sheet name is Sheet1. I'm think that it looks as if the sheet has no name when I try to open it in Excel XP. I don't know of any work around.

    Thanks for your time

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Excel File (Excel XP)

    It is not valid for a sheet to not have a name. In XL2K, if you try to delete a sheet's name you will get an error. The fact that XL2K will open a file with a sheet with no name is a bug that was apparently fixed in XP.
    Legare Coleman

  5. #5
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Excel File (Excel XP)

    Thanks Legare

    Do you know of any work around. A code that can bypass the message?

    Thanks

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Excel File (Excel XP)

    The only work around that I can think of would be to give the sheet a name.
    Legare Coleman

Posting Permissions

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