Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs to different filesystem causes unreadable content
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs to different filesystem causes unreadable content
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. On Feb 25, 11:47*am, Carl Hartness wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs to different filesystem causes unreadable content
On Feb 26, 1:47*am, Carl Hartness wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UNREADABLE CONTENT | Excel Discussion (Misc queries) | |||
excel found unreadable content | Excel Discussion (Misc queries) | |||
Excel found unreadable content | Excel Discussion (Misc queries) | |||
unreadable content with no further actions | Excel Discussion (Misc queries) | |||
unreadable content | Excel Discussion (Misc queries) |