Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    excel 97 file will not open in excel 2000 (excel 2000)

    When trying to open this one file in excel 2000 I get this error message.
    An error occurred while loading 'Sheet611221223121112111121413211'. Do you want to continue loading the project?

    If I answer yes the excel loads the file but I get an illegal operation message and then it closes excel.

    No problem with other files just this one and it used to open for me.

    Thanks for any help.

    Robby

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: excel 97 file will not open in excel 2000 (excel 2000)

    Robby <img src=/S/hello.gif border=0 alt=hello width=25 height=29>

    It seems that this workbook is corrupted. Maybe you need to find that old backup copy and see if you can recreate the workbook from it.

    Sorry <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    New Lounger
    Join Date
    Nov 2001
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel 97 file will not open in excel 2000 (excel 2000)

    I would agree with that but this file can still be opened in office 97 without any problems.
    It just has problems with office 2000.

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

    Re: excel 97 file will not open in excel 2000 (excel 2000)

    If you can manage to open the file in Office 97, do so and go the VB editor and make sure you have the view properties window open (F4 should open it). Highlight the sheet that is causing the problem (the one with that long name) and change the name property. There are 2 name properties, one in brackets which is the codename. Change the appropriate on to something much shorter, as that might be causing the problem. If you see other sheets with similarly long names try renaming them also to something mmore reasonable. Excel should reeally apply sheet names itself that will cause it problems, but it does seem to.

    I just tried to apply that very name to a sheet and excel rejected it. It did not reject a name one character less. Copying and recopying sheets can lead to these absurdly long names. I copied the sheet with one character less and it created a new sheet with the name si given by you. I closed the file and tried to open in Excel 2000 and got the same proplem as you, see error attached. Excel crashed. The file opened ok in Excel 97

    Andrew C
    Attached Images Attached Images

  5. #5
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: excel 97 file will not open in excel 2000 (excel 2000)

    Andrew

    <<< I just tried to apply that very name to a sheet and excel rejected it. It did not reject a name one character less. >>>

    A sheet name can be 32 character long, but maybe they mean 31 character long.

    The name is 32 character long, so AFAIK it should be OK.

    Do you think this sheet was one of the sheets copied over how many ever times? You know when Excel places something like Sheet1 (2) when you have the same sheet name?

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

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

    Re: excel 97 file will not open in excel 2000 (excel 2000)

    Wassim,

    Well when I try to name a sheet with Sheet611221223121112111121413211, I get an Improper Property Value message. Remove a character and all is well. You can copy the sheet and it will append another 1 (thus making 32 characters - maybe XL thinks it alone should have have the honour of applying the last character - though I have no idea why XL2000 has troubles with it, but it does), so creating the above sheet name. On attempting to copy the copy, nothing happened - no complaints, no sheet copied.

    That sheet would appear to have started out as a Sheet 6 which seems to have spawned many other copies ( I think 1 represents a first copy of the preceeding sheet, 2 the second copy etc.). As you can see not all this fellows ancestors not first born. When you copy say Sheet1 Excel uses Sheet1(2) as the (tab) name, but may very well use an absurdly created name like the above as the code name. See the properties attached of the sheet I copied, which has the above codename (the first entry in the properties window, shown as (name) ).

    Andrew
    Attached Images Attached Images

  7. #7
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: excel 97 file will not open in excel 2000 (excel 2000)

    Robby

    As Andrew had pointed out, it could be the sheet name. I know that the limit is around 32 characters and that your sheet name was within limits, first thing I checked, but the header of the workbook is what is corrupted, its the part that tells the application what to do with the workbook, and other info as well.

    MS-Excel maybe more forgiving that MS-Excel 2000 and that is why it could open the workbook. Maybe you can re-save the workbook in 97 under a different name and then try to open it in 2000.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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