Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Serious problem when opening a file
Sometimes opening and saving in a different version of excel can help (sometimes
not). If it is a corrupted workbook, you may want to try openoffice. Lots of people have said that it's recovered workbooks that excel couldn't. (http://www.openoffice.org, a 60-65 meg download or a CD) If the file is really important, there are commercial recovery services. I've never used it, but you might want to check into: http://www.officerecovery.com Antonio wrote: I have a large .xls file with plenty of VBA, links, data etc. It opens and works fine on one PC. However, in the main PC it takes about 8 minutes to open. When it opens it works fine. But when I open it again it says "unable to open file" and later on I get "file had too many errors" and that is the end of the file. I have been working on this problem for days already. Following the instructions I received here, I deleted all the temp files. It worked for three days, now I am back with the same problem. I even removed and reinstalled Office 2003. Any ideas? Many thanks, Antonio -- Dave Peterson |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Serious problem when opening a file
Any chance you have a hidden worksheet named Misctables?
Since you're working with names, get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp It might make finding/fixing these names easier. Antonio wrote: Thank you Alok and Dave for your suggestions. I have tried all of them except for openoffice and professional services. In the end what I have done is to create a new spreadsheet where I have copied one by one every of the dozen sheets. I got error message like HTML_Control name already exists, several times. I had to give a new name. I have never created an HTML_Control name. The several new HTML_Control1, ..Control2. etc names that I created are in the Names list, referring to ={"'MiscTables'!$B$2:$E$6","'MiscTables'!$B$7:$E$2 1"} I don't know what this MiscTables refer to, it is not certainly a sheet that I have. I have deleted one of those names but they stay there. After copying the VBA modules one by one, everything seems to be working fine but any ideas about this HTML_Control names? Thanks, Antonio "Dave Peterson" wrote: Sometimes opening and saving in a different version of excel can help (sometimes not). If it is a corrupted workbook, you may want to try openoffice. Lots of people have said that it's recovered workbooks that excel couldn't. (http://www.openoffice.org, a 60-65 meg download or a CD) If the file is really important, there are commercial recovery services. I've never used it, but you might want to check into: http://www.officerecovery.com Antonio wrote: I have a large .xls file with plenty of VBA, links, data etc. It opens and works fine on one PC. However, in the main PC it takes about 8 minutes to open. When it opens it works fine. But when I open it again it says "unable to open file" and later on I get "file had too many errors" and that is the end of the file. I have been working on this problem for days already. Following the instructions I received here, I deleted all the temp files. It worked for three days, now I am back with the same problem. I even removed and reinstalled Office 2003. Any ideas? Many thanks, Antonio -- Dave Peterson -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Serious problem when opening a file
Keep a backup--just like any other file.
Antonio wrote: Thank you Dave. I did not have any hidden worksheet. I have installed and run Name Manager. It seems quite good. Many thanks. I had a lot of HTML_Control names and many others that I have removed. Workbook seems to be working fine. So far I am very happy. Regards, Antonio "Dave Peterson" wrote: Any chance you have a hidden worksheet named Misctables? Since you're working with names, get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp It might make finding/fixing these names easier. Antonio wrote: Thank you Alok and Dave for your suggestions. I have tried all of them except for openoffice and professional services. In the end what I have done is to create a new spreadsheet where I have copied one by one every of the dozen sheets. I got error message like HTML_Control name already exists, several times. I had to give a new name. I have never created an HTML_Control name. The several new HTML_Control1, ..Control2. etc names that I created are in the Names list, referring to ={"'MiscTables'!$B$2:$E$6","'MiscTables'!$B$7:$E$2 1"} I don't know what this MiscTables refer to, it is not certainly a sheet that I have. I have deleted one of those names but they stay there. After copying the VBA modules one by one, everything seems to be working fine but any ideas about this HTML_Control names? Thanks, Antonio "Dave Peterson" wrote: Sometimes opening and saving in a different version of excel can help (sometimes not). If it is a corrupted workbook, you may want to try openoffice. Lots of people have said that it's recovered workbooks that excel couldn't. (http://www.openoffice.org, a 60-65 meg download or a CD) If the file is really important, there are commercial recovery services. I've never used it, but you might want to check into: http://www.officerecovery.com Antonio wrote: I have a large .xls file with plenty of VBA, links, data etc. It opens and works fine on one PC. However, in the main PC it takes about 8 minutes to open. When it opens it works fine. But when I open it again it says "unable to open file" and later on I get "file had too many errors" and that is the end of the file. I have been working on this problem for days already. Following the instructions I received here, I deleted all the temp files. It worked for three days, now I am back with the same problem. I even removed and reinstalled Office 2003. Any ideas? Many thanks, Antonio -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem opening file | Excel Discussion (Misc queries) | |||
Problem opening a file | Excel Discussion (Misc queries) | |||
opening a file problem | Excel Programming | |||
Problem opening a file | Excel Programming | |||
opening file problem please help | Excel Discussion (Misc queries) |