"Unreadable content" in simple files

[MatWard]

I am getting a recurring problem with my Excel 2007 files (xmlx). There's
nothing very complex here - a data dump of maybe 20,000 lines in one sheet, a
few extra columns added with VLOOKUP to categories the data, and then a few
summary sheets each using the nice new SUMIFS formula maybe 700 times each.

Once in a while, when I open the file it says "Excel found unreadable
content in 'Filename.xlmx'. Do you want to recover the contents of this
workbook?". When I select yes, it opens my workbook but gives a little window
warning about Repairs that were made and lists a few xml items that were
removed.

Unfortunately, these xml items are a random scattering of formulae
throughout the workbook that are replaced with values (or, sometimes, N/A).
It's not normally the more complex formulae that are replaced, just something
simple like "SUM".

It's incredibly irritating, because it doesn't tell you WHICH cells have
been replaced.

I pulled the whole thing together from scratch in about 2 hours and always
saved in xmlx format, so it shouldn't be anything to do with compatibility
between 2007 and older versions.

Has anyone else been experiencing anything similar? Any fixes that you can
recommend? Or any way of quickly identifying which cells have been turned to
values? (At the moment, I'm forced to switch to formula view [CTRL-'] and
find them by eye). The only similar thing on the MS support site relates to
pivot tables, and there aren't any in this workbook.

Thanks.

 

[ShaneDevenshire]

Hi,

This should help you

http://support.microsoft.com/kb/929766/en-us

 

[MatWard]

Thanks, but that link explicitly says that this fixes the error message
associated with the recovery report "Removed Records: PivotTable report from
/xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)"

It also makes it clear that the cause of this error is the pivot table in
the workbook: My file contains no pivot tables and I did not receive this
recovery message.

The only other notable thing I could mention is that I'm accessing the files
on a shared corporate network.

Happy to email the file. It really doesn't contain anything interesting.

Hi,

This should help you

http://support.microsoft.com/kb/929766/en-us

--
Thanks,
Shane Devenshire

I am getting a recurring problem with my Excel 2007 files (xmlx). There's
nothing very complex here - a data dump of maybe 20,000 lines in one sheet, a
few extra columns added with VLOOKUP to categories the data, and then a few
summary sheets each using the nice new SUMIFS formula maybe 700 times each.

Once in a while, when I open the file it says "Excel found unreadable
content in 'Filename.xlmx'. Do you want to recover the contents of this
workbook?". When I select yes, it opens my workbook but gives a little window
warning about Repairs that were made and lists a few xml items that were
removed.

Unfortunately, these xml items are a random scattering of formulae
throughout the workbook that are replaced with values (or, sometimes, N/A).
It's not normally the more complex formulae that are replaced, just something
simple like "SUM".

It's incredibly irritating, because it doesn't tell you WHICH cells have
been replaced.

I pulled the whole thing together from scratch in about 2 hours and always
saved in xmlx format, so it shouldn't be anything to do with compatibility
between 2007 and older versions.

Has anyone else been experiencing anything similar? Any fixes that you can
recommend? Or any way of quickly identifying which cells have been turned to
values? (At the moment, I'm forced to switch to formula view [CTRL-'] and
find them by eye). The only similar thing on the MS support site relates to
pivot tables, and there aren't any in this workbook.

Thanks.