A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel 2007 Error Reopening Pivot tables



 
 
Thread Tools Display Modes
  #1  
Old November 15th, 2006, 09:08 PM posted to microsoft.public.excel.setup
Mike L
external usenet poster
 
Posts: 29
Default Excel 2007 Error Reopening Pivot tables

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?

--
Mike L
  #2  
Old November 15th, 2006, 09:33 PM posted to microsoft.public.excel.setup
Mike L
external usenet poster
 
Posts: 29
Default Excel 2007 Error Reopening Pivot tables

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.
--
Mike L


"Mike L" wrote:

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?

--
Mike L

  #3  
Old November 20th, 2006, 06:41 PM posted to microsoft.public.excel.setup
Mike L
external usenet poster
 
Posts: 29
Default Excel 2007 Error Reopening Pivot tables

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?
--
Mike L


"Mike L" wrote:

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.
--
Mike L


"Mike L" wrote:

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?

--
Mike L

  #4  
Old November 20th, 2006, 09:57 PM posted to microsoft.public.excel.setup
Mike L
external usenet poster
 
Posts: 29
Default Excel 2007 Error Reopening Pivot tables

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?
--
Mike L


"Mike L" wrote:

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?
--
Mike L


"Mike L" wrote:

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.
--
Mike L


"Mike L" wrote:

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?

--
Mike L

  #5  
Old November 21st, 2006, 05:15 PM posted to microsoft.public.excel.setup
Mike L
external usenet poster
 
Posts: 29
Default Excel 2007 Error Reopening Pivot tables

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.

--
Mike L


"Mike L" wrote:

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?
--
Mike L


"Mike L" wrote:

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?
--
Mike L


"Mike L" wrote:

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.
--
Mike L


"Mike L" wrote:

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?

--
Mike L

  #6  
Old November 21st, 2006, 10:48 PM posted to microsoft.public.excel.setup
Mike L
external usenet poster
 
Posts: 29
Default Excel 2007 Error Reopening Pivot tables

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
--
Mike L


"Mike L" wrote:

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.

--
Mike L


"Mike L" wrote:

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?
--
Mike L


"Mike L" wrote:

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?
--
Mike L


"Mike L" wrote:

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.
--
Mike L


"Mike L" wrote:

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?

--
Mike L

  #7  
Old November 24th, 2006, 10:53 PM posted to microsoft.public.excel.setup
Mike L
external usenet poster
 
Posts: 29
Default Excel 2007 Error Reopening Pivot tables

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.
--
Mike L


"Mike L" wrote:

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
--
Mike L


"Mike L" wrote:

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.

--
Mike L


"Mike L" wrote:

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?
--
Mike L


"Mike L" wrote:

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?
--
Mike L


"Mike L" wrote:

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.
--
Mike L


"Mike L" wrote:

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?

--
Mike L

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.