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 |
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 |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com