Excel 2000 can't open file created in Excel 97 
Author Message
 Excel 2000 can't open file created in Excel 97

I've created a time sheet file in Excel 97 that has a sheet for every week.
Basically, there are certain items linked within the sheets such as annual
leave and credited hours.

I've had no problem opening these files in Excel 97 but when I try to open
the file within Excel 2000. I first get the error message:
"An error occurred while loading 'Sheet 1111111111111111111111111111'.  Do
you want to continue loading the project."

When I click yes, I get:
"Excel caused an invalid page fault in module vb6.dll at 0187:650f6290"
Then Excel closes.

I'm curious to what could be causing this (a macro?) and how to cure this.
The only way around it would be to redo the thing again in Excel 2000, at
the very least a 1/2 days work

TIA.

--
Todd Ryan
Network Admin



Sat, 05 Jul 2003 03:30:03 GMT  
 Excel 2000 can't open file created in Excel 97
This is a bug in XL97 that happens when you repeatedly *copy* a worksheet. XL
incorrectly keeps adding the digit 1 to the internal sheet name, until the
name exceeds the limit of 32 characters.

If you can still open it in XL97, I suggest you do that, then go to the VB
Editor, select this workbook in the Project pane, then under Microsoft Excel
Objects, select each worksheet in turn and change the name down (the one that
ends with the string of 1's) in the properties pane.

If you can no longer open the workbook, you can try opening it in Word (but
with 52 sheets, that's problematic). Or to retrieve the data, you can start a
new workbook, and use formulas that refer to the original, i.e. in A1, write
something like:

  ='C:\EXCEL\[BadBook.xls]Sheet1'!$A$1

and copy that to the right and down as far as necessary. That will retrieve
values, not formulas.

If that doesn't work or isn't sufficient, you're stuck with re-creating it.

BTW, this bug was fixed in XL2000, but it seems the trade-off is that the book
that XL97 corrupted can no longer be opened.

Quote:

>I've created a time sheet file in Excel 97 that has a sheet for every week.
>Basically, there are certain items linked within the sheets such as annual
>leave and credited hours.

>I've had no problem opening these files in Excel 97 but when I try to open
>the file within Excel 2000. I first get the error message:
>"An error occurred while loading 'Sheet 1111111111111111111111111111'.  Do
>you want to continue loading the project."

>When I click yes, I get:
>"Excel caused an invalid page fault in module vb6.dll at 0187:650f6290"
>Then Excel closes.

>I'm curious to what could be causing this (a macro?) and how to cure this.
>The only way around it would be to redo the thing again in Excel 2000, at
>the very least a 1/2 days work



Sat, 05 Jul 2003 03:46:05 GMT  
 Excel 2000 can't open file created in Excel 97
Hi Todd,

To avoid the problem in future, save the "original" of the sheet as a
template (.xlt). Open the workbook you want the sheet in, click New, click
on your sheet template, when it opens, move it into the workbook, name it
01-1 or whatever you like, & proceed as usual.

This avoids the repeated copying that causes the problem. Thanks, Myrna, for
explaining why this happens! I figured out its connection to repeated
copying, but had no idea of the mechanism.

Using the template is also cleaner & more efficient. I originally switched
to that method because it was easier & quicker, not because of the bug. I
think you will prefer it too.

Susan


Quote:
> I've created a time sheet file in Excel 97 that has a sheet for every
week.
> Basically, there are certain items linked within the sheets such as annual
> leave and credited hours.

> I've had no problem opening these files in Excel 97 but when I try to open
> the file within Excel 2000. I first get the error message:
> "An error occurred while loading 'Sheet 1111111111111111111111111111'.  Do
> you want to continue loading the project."

> When I click yes, I get:
> "Excel caused an invalid page fault in module vb6.dll at 0187:650f6290"
> Then Excel closes.

> I'm curious to what could be causing this (a macro?) and how to cure this.
> The only way around it would be to redo the thing again in Excel 2000, at
> the very least a 1/2 days work

> TIA.

> --
> Todd Ryan
> Network Admin




Sat, 05 Jul 2003 04:40:36 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Strange file created during SaveAs from Excel 2000 to Excel 2000/97 compatible

2. printing problem : excel 2000 with excel 97 created file

3. Can't open file created in Excel 97

4. Can't load Excel 97 file into Excel 2000

5. error saving and opening excel 97 vba file in excel 2000

6. error when saving and opening Excel 97 VBA file in Excel 2000

7. Automation Error when open excel 97 file in excel 2000

8. Excel 97 on Windows 2000 won't open files with Macros

9. Excel 97 on Windows 2000 won't open files with Macros

10. Opening Excel 2000 files in Excel 97


 
Powered by phpBB® Forum Software © phpBB Group