41111111 etc. error

philip38 · May 16th, 2002, 07:55 AM

An Excel97 user is getting the following error when adding a new sheet. "An error occurred while loading sheet 41111111111 etc.
It looks like it's over the 31 character limit. But what do I do to save her workbook? It does not open at all in Excel 2000.

sann0638 · May 16th, 2002, 09:52 AM

"If you've already got this error, and if it's possible to open it, save the file down to Excel 5.0, close it, reopen, and save as your current version again. Or open it in Excel XP, which often fixes the document for you--even after you have been unable to open it in lesser versions."

Copied from: http://www.thewordexpert.com

Don't know if it works, but worth a try.

Rgds,
mike

[ This Message was edited by: sann0638 on 2002-05-16 08:52 ]

klb · May 16th, 2002, 11:21 AM

Is a new sheet being added or is another sheet being copied?

If it is another sheet being copied, you need to edit the sheet name in the VBA editor. Whenever a sheet is copied, it adds another 1 to the sheet (name) in VBA.

philip38 · May 16th, 2002, 01:23 PM

RE: 41111111 etc. error
THe suggestion about opening in Office XP worked. Thanks to all and in particular to mike (sann0638)

Philip 38

May 16th, 2002, 11:21 AM	#3
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	Is a new sheet being added or is another sheet being copied? If it is another sheet being copied, you need to edit the sheet name in the VBA editor. Whenever a sheet is copied, it adds another 1 to the sheet (name) in VBA. __________________ Curiosity may have killed the cat but... satisfaction brought it back. >^;^<

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 07:55 AM	#1
philip38 New Member Join Date: May 2002 Posts: 15	An Excel97 user is getting the following error when adding a new sheet. "An error occurred while loading sheet 41111111111 etc. It looks like it's over the 31 character limit. But what do I do to save her workbook? It does not open at all in Excel 2000.

May 16th, 2002, 09:52 AM	#2
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	"If you've already got this error, and if it's possible to open it, save the file down to Excel 5.0, close it, reopen, and save as your current version again. Or open it in Excel XP, which often fixes the document for you--even after you have been unable to open it in lesser versions." Copied from: http://www.thewordexpert.com Don't know if it works, but worth a try. Rgds, mike [ This Message was edited by: sann0638 on 2002-05-16 08:52 ]

May 16th, 2002, 01:23 PM	#4
philip38 New Member Join Date: May 2002 Posts: 15	RE: 41111111 etc. error THe suggestion about opening in Office XP worked. Thanks to all and in particular to mike (sann0638) Philip 38