Problem saving 2003 file in 2007

Topic

New Reply

I have worksheets created with Excel, perhaps as far back as Excel 4. They were last saved in Excel 2003, I believe in 2003 file format. When I try to save them using 2007 I get “[file name].xls cannot be saved in the current format. To save your changes, click OK, then save it as the latest format.”

I made no changes. I simply opened the file and hit save. This only happens to some files. I am trying to find a common denominator.

Reply | Quote

Replies

I have worksheets created with Excel, perhaps as far back as Excel 4. They were last saved in Excel 2003, I believe in 2003 file format. When I try to save them using 2007 I get “[file name].xls cannot be saved in the current format. To save your changes, click OK, then save it as the latest format.”

I made no changes. I simply opened the file and hit save. This only happens to some files. I am trying to find a common denominator.

this is mainly due to compatibility issues. please read this
http://office.microsoft.com/en-us/excel-help/use-office-excel-2007-with-earlier-versions-of-excel-HA010077561.aspx
thanks and enjoy

Reply | Quote

I’d suspect that the problem ones were originally saved with Excel 5/95 compatibility.

Reply | Quote

I’d suspect that the problem ones were originally saved with Excel 5/95 compatibility.

I believe you got it right, Rory. Further (but I am not sure yet), It only seems to be those with Excel 5 macros saved in compatibility mode.

Thanks to both of you for the help.

Reply | Quote