Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 16th 05, 10:05 AM
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  
Old February 19th 05, 02:22 AM
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
How Do I open an excel file without Excel Viewer support CocoriteBallGiants Excel Discussion (Misc queries) 2 February 4th 05 11:50 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 01:37 AM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 09:36 AM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 11:20 PM
Saving a Excel 97 file into Excel 2003 file Wil Excel Discussion (Misc queries) 1 December 14th 04 12:51 AM


All times are GMT +1. The time now is 09:16 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017