SaveAs to different filesystem causes unreadable content

[Carl Hartness]

I have an Excel file being corrupted by SaveAs. The problem occurs
when I open it from a filesystem folder (local or networked hard disk
in NTFS format, or removable Flash media in FAT format), and SaveAs to
another filesystem (a different local or networked hard disk, or a
different removable Flash media). When I attempt to open the new
file, the displayed error is
"Excel found unreadable content in 'test file 123.xls'. Do you want
to recover the contents of this workbook? If you trust the source of
this workbook, click Yes."

If I continue with the recovery, data and formulas are recovered, but
formatting and macros are lost.

The file is a modest size, 1.6 MB, lots of formulas, no external
links.

This occurs on XP and Vista, on Excel 2003 and 2007.

With 2007, when the SaveAs is to Macro enabled XML format, the
"unreadable content" message occurs, but the recovery seems to be
complete.

 

[Carl Hartness]

I see that I didn't ask a question! The question is, what might be
different about this file that causes this behavior?

Thanks.
Carl.

 

[fyz]

I have anExcelfile being corrupted by SaveAs.  The problem occurs
when I open it from a filesystem folder (local or networked hard disk
in NTFS format, or removable Flash media in FAT format), and SaveAs to
another filesystem (a different local or networked hard disk, or a
different removable Flash media).  When I attempt to open the new
file, the displayed error is
  "Excelfound unreadable content in 'test file 123.xls'.  Do you want
torecoverthe contents of this workbook?  If you trust the source of
this workbook, click Yes."

If I continue with the recovery, data and formulas are recovered, but
formatting and macros are lost.

The file is a modest size, 1.6 MB, lots of formulas, no external
links.

This occurs on XP and Vista, onExcel2003 and 2007.

With 2007, when the SaveAs is to Macro enabled XML format, the
"unreadable content" message occurs, but the recovery seems to be
complete.

Hi Carl Hartness,

You may try a popular Excel file recovery tool called Advanced Excel
Repair to repair your Excel file. It is a powerful tool to repair
corrupt or damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Hope the information will help.

Alan