Excel 2007 Error Reopening Pivot tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike L - 15 Nov 2006 20:08 GMT

Has anyone got the error:
"Excel has found unreadable content"
and then
"Removed records: PivotTable report from
/xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable Cache)"
when all spreadsheets with pivot tables are saved and then reopened.
This did occur on the B2TR but it also occurs in the Offical release.
I unistalled Office B2TR and then installed Official Office 2007.
I have deleted my profile and reinstalled Office 2007 twice and the error is
solid for all spreadsheets with pivot tables.
Help?

Signature

Mike L

Reply to this Message

Mike L - 15 Nov 2006 20:33 GMT

As A further test, when I opened the pivot table spreadseets constructed with
B2TR, it correctly wanted to upgrade them and resave them. It also gave the
same error when it was trying to upgrade the old spreadsheet. When the
corrected spreadshhet was saved and reopened, then it gave the same error
again.
Very puzzling.

Signature

Mike L

> Has anyone got the error:
> "Excel has found unreadable content"
[quoted text clipped - 7 lines]
> solid for all spreadsheets with pivot tables.
> Help?

Reply to this Message

Mike L - 20 Nov 2006 17:41 GMT

I installed the production version of Excel 2007 on a different machine and
sadly repeated the same error where a saved spreadsheet with a pivot table
always gave the error when it was reopened. It looks like a solid issue -
anyone know of a workaround to suppress the error displays?

Signature

Mike L

> As A further test, when I opened the pivot table spreadseets constructed with
> B2TR, it correctly wanted to upgrade them and resave them. It also gave the
[quoted text clipped - 14 lines]
> > solid for all spreadsheets with pivot tables.
> > Help?

Reply to this Message

Mike L - 20 Nov 2006 20:57 GMT

It may be of interrest that when such a pivot table spread sheet is published
to MOSS 2007 B2TR, the Excel Services cannot display it (it considers it to
be a corrupted file). When you allow it to be opened with Excel itself, the
error above is repeated. I think I need to revent back to Excel 2007 B2TR
until this issue is resolved.
Any suggestions?

Signature

Mike L

> I installed the production version of Excel 2007 on a different machine and
> sadly repeated the same error where a saved spreadsheet with a pivot table
[quoted text clipped - 19 lines]
> > > solid for all spreadsheets with pivot tables.
> > > Help?

Reply to this Message

Mike L - 21 Nov 2006 16:15 GMT

So I deleted the partition on my PC and reinstalled WIndows Server 2003 after
a reformat of the disk. I then installed Office 2007 RTM. I then created a
new spreadsheet with a Pivot table connected to my OLAP cube. I saved the
spreadsheet. I reopened the spreadsheet and immediately got the error.

Signature

Mike L

> It may be of interrest that when such a pivot table spread sheet is published
> to MOSS 2007 B2TR, the Excel Services cannot display it (it considers it to
[quoted text clipped - 26 lines]
> > > > solid for all spreadsheets with pivot tables.
> > > > Help?

Reply to this Message

Mike L - 21 Nov 2006 21:48 GMT

I have done more tests and the error is caused by a complex OLAP cube.
Apparently a complex cube as the external data source of a pivot table causes
Excel to output a corrupted XML file for the spreadsheet when it is saved.
Excel might need to be fixed

Signature

Mike L

> So I deleted the partition on my PC and reinstalled WIndows Server 2003 after
> a reformat of the disk. I then installed Office 2007 RTM. I then created a
[quoted text clipped - 31 lines]
> > > > > solid for all spreadsheets with pivot tables.
> > > > > Help?

Reply to this Message

Mike L - 24 Nov 2006 21:53 GMT

The latest tests indicate that Excel 2007 will save a corrupted spreadsheet
if the OLAP cube or perspective opened has any KPI's defined. The resulting
saved spreadsheet cannot be opened by either Excel 2007 nor Excel Services in
MOSS 2007.

Signature

Mike L

> I have done more tests and the error is caused by a complex OLAP cube.
> Apparently a complex cube as the external data source of a pivot table causes
[quoted text clipped - 36 lines]
> > > > > > solid for all spreadsheets with pivot tables.
> > > > > > Help?

Reply to this Message