Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recovered file has "File format is not valid" error
I am using Excel 2007 SP1 (12.0.6504.5001)
I have had a few problems with Excel crashing when I am editing vba code. I am saving in Excel 2003 compatible format. Up to now I have been able to use the "Version created during recovery" when this happens. But now the problem is more frequent (crash every 5-10 mins) and I have the error "File Format is not valid" when I try to open the recoverd version. This version also has a red comment "Repaired" under it. Can anyone help me make crashes less frequent and get round the invalid format problem? Thanks John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recovered file has "File format is not valid" error
Try developing your application entirely by saving in xl2007 macro enabled
format and then save as xl97-2003 format when finished. I have experienced the problem you describe (usually due to code errors) but have been able to recover better if saved in xl2007 format. (There is still no substitute for frequently Saving As and creating versions of your project and do this just before running the code to test. Also Debug - Compile before running the code) You should note that saving in the earlier version format does not limit the use of functions and code etc to the earlier version. I have found that at least some, if not all, xl2007 functions and code will still work while opened in xl2007 and saved in xl97-2003 format. XL2007 does provide a warning message when saving in the earlier version but that does not prevent functions and code pertaining only to xl2007 from being used. However, they fail when the workbook is opened and run in the earlier version. -- Regards, OssieMac "JBRC Chorus" wrote: I am using Excel 2007 SP1 (12.0.6504.5001) I have had a few problems with Excel crashing when I am editing vba code. I am saving in Excel 2003 compatible format. Up to now I have been able to use the "Version created during recovery" when this happens. But now the problem is more frequent (crash every 5-10 mins) and I have the error "File Format is not valid" when I try to open the recoverd version. This version also has a red comment "Repaired" under it. Can anyone help me make crashes less frequent and get round the invalid format problem? Thanks John |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recovered file has "File format is not valid" error
OssieMac wrote:
Try developing your application entirely by saving in xl2007 macro enabled format and then save as xl97-2003 format when finished. Or better develop under the stable environment of xl2003 and move it to XL2007 when it is already working. I have experienced the problem you describe (usually due to code errors) but have been able to recover better if saved in xl2007 format. (There is still no substitute for frequently Saving As and creating versions of your project and do this just before running the code to test. Also Debug - Compile before running the code) You should note that saving in the earlier version format does not limit the use of functions and code etc to the earlier version. I have found that at least some, if not all, xl2007 functions and code will still work while opened in xl2007 and saved in xl97-2003 format. XL2007 does provide a warning message when saving in the earlier version but that does not prevent functions and code pertaining only to xl2007 from being used. However, they fail when the workbook is opened and run in the earlier version. Developing under XL2003 avoids this gotcha too. XL2007 is fragile and/or slow if you are doing the wrong sorts of things. I have never had it lose a file to "format not valid" yet but there is always a first time. Regards, Martin Brown |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"File Error: Data May Be Lost" when file saved on Mac is opened inWindows | Excel Discussion (Misc queries) | |||
file format or file extension is not valid...error message | Excel Discussion (Misc queries) | |||
error says "file format not valid" | Excel Discussion (Misc queries) | |||
Error message "File format is not valid" | Excel Discussion (Misc queries) | |||
"File Format Not Valid" When Starting Excel. Error Code 0D3F6000 | Excel Discussion (Misc queries) |