Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) |