Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jp
 
Posts: n/a
Default error opening excel file

hi!
i cannot open this excel file, an microsoft visual basic window appear
saying "An error occur while loading 'Sheet32111111111111111111111111'. Do
you want to continue loading the project?"

i click yes, microsoft window appear and asking if i want to update this
workbook? then i click no a Program Error window appear saying " An error
log is being created"
what happen to the excel file?
the excel file is only 2.6Mb



  #2   Report Post  
Gary Brown
 
Posts: n/a
Default

JP,
A couple of issues.
First is the Sheet name. This is the 'real' name of the worksheet, not the
one you see on the worksheet tab. You have to go into the Visual Basic
Editor to see it in the properties window. That's where you can shorten the
name. Excel has a problem with really long Worksheet names. The way a name
like 'Sheet32111111111111111111111111' happens is if you keep copying a
copied worksheet over and over and over and over..... again. Excel keeps
adding a '1' to the end of the previous name so that 'Sheet321' becomes
'Sheet3211' which becomes 'Sheet321111', etc. until it basically explodes.
Second issue is a kicker. If you can't open that file to change the name
and you REALLY need that information you can copy the information to a new
workbook/worksheet but it's going to look REALLY ugly.
The google search below goes to a thread that can, hopefully, guide you
through.
Good Luck.
Gary Brown

Thread at... (you will probably have to patch this address back together)
http://groups-beta.google.com/group/...c94a8006b1be28





"jp" wrote in message
...
hi!
i cannot open this excel file, an microsoft visual basic window appear
saying "An error occur while loading 'Sheet32111111111111111111111111'. Do
you want to continue loading the project?"

i click yes, microsoft window appear and asking if i want to update this
workbook? then i click no a Program Error window appear saying " An error
log is being created"
what happen to the excel file?
the excel file is only 2.6Mb





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How Do I open an excel file without Excel Viewer support CocoriteBallGiants Excel Discussion (Misc queries) 2 February 4th 05 10:50 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 10:20 PM
Saving a Excel 97 file into Excel 2003 file Wil Excel Discussion (Misc queries) 1 December 13th 04 11:51 PM


All times are GMT +1. The time now is 06:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"