Unreadable Content Error

B

bbal20

I keep getting an error the reads "Excel found unreadable conten in
"Book.xlsx". Do you want to recover the contents of this
workbook?.................". When I click "Yes" it removes the Pivot tables
in my workbook. It gives me the following log repair file:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error047640_01.xml</logFileName>
<summary>Errors were detected in file 'C:\Documents and
Settings\kpatterson\Desktop\DASH\New Daily DashBoard.xlsx'</summary>
- <removedParts summary="Following is a list of removed parts:">
<removedPart>Removed Part: /xl/pivotTables/pivotTable1.xml part.
(PivotTable view)</removedPart>
<removedPart>Removed Part: /xl/pivotTables/pivotTable2.xml part.
(PivotTable view)</removedPart>
</removedParts>
- <removedFeatures summary="Following is a list of removed features:">
<removedFeature>Removed Feature: PivotTable report from
/xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable
cache)</removedFeature>
<removedFeature>Removed Feature: PivotTable report from
/xl/pivotCache/pivotCacheDefinition2.xml part (PivotTable
cache)</removedFeature>
</removedFeatures>
- <removedRecords summary="Following is a list of removed records:">
<removedRecord>Removed Records: Workbook properties from /xl/workbook.xml
part (Workbook)</removedRecord>
</removedRecords>
</recoveryLog>

Can anyone help me out? Please advise. Thank you.
 
J

Jan Karel Pieterse

Hi Bbal20,
I keep getting an error the reads "Excel found unreadable conten in
"Book.xlsx". Do you want to recover the contents of this
workbook?.................". When I click "Yes" it removes the Pivot tables
in my workbook. It gives me the following log repair file:
Click to expand...

What happens if you remove the pivots, save, close and open the file and
recreate the pivot tables?

(!keep a backup copy of your file just in case!)

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
S

Simon Murphy

Pivot caches are a common cause of corruption in E2007. What type of
pivot table is/was it? (2007 or 2003 compatible)
Creating a 2003 compatible pivot doesn't work well especially in .xlsx
formats.
If you need 2003 compatibility use E2003 to create your pivot.

If not (I assume this as you are saving as .xlsx) then use a 2007
style/structure pivot.

Cheers
Simon
Excel development website: www.codematic.net
 
K

Ken Ent

We are currently experiencing a similar problem but the worksheets do not
include any pivot tables, only ODBC extracts. They are extracted and saved
in xlsx format but keep getting this error. When it recovers, it removes the
xml portions of the table.
 
J

Jan Karel Pieterse

Hi Ken,
We are currently experiencing a similar problem but the worksheets do not
include any pivot tables, only ODBC extracts. They are extracted and saved
in xlsx format but keep getting this error. When it recovers, it removes the
xml portions of the table.
Click to expand...

Tables imported using MSQuery often lead to corruptions in Excel 2007. The
workaround I use is to pull in the data using VBA+ADO and then use
CopyFromRecordSet to push the data to Excel.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
L

Lance

This problem with the external data connections is driving me crazy. I've
got a lot of tools that use these ODBC table queries to refresh accounting
data. Do you have a good source that can teach the ADO VBA method you
mention below?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel found unreadable content in file error. 0
I Have an error in one of my worksheet 0
Excel found unreadable content in "workbook.xlsm" 2
Can't save changes to worksheet. 1
error on saving 0
comments 0
lost charts 0
Unreadable Content Errors 1

Top