Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2005

Tip: Looking for answers? Try searching our database.

Pivot table discarded to due to integrity problems

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ZZZ - 16 Sep 2005 19:25 GMT
Hi,

I have a client with a mid-sized workbook. On one page is a pivot table.
Occasionally, upon opening the workbook an message appears about errors
being detected in the pivot table. The result is that the workbook opens,
but the worksheet with the pivot has now become "flat data". The buttons are
gone, and the data is just static data, the ability to do any pivot
manipulation is gone.

This problem is not consistent.

Has anyone run across this before?  Any ideas to avoid it?

Thanks,
KB
Debra Dalgleish - 16 Sep 2005 21:45 GMT
The information in the following MSKB article may help you:

"Unable to read file" error message when you open Excel file that
contains a PivotTable report
  http://support.microsoft.com/default.aspx?id=819853

> Hi,
>
[quoted text clipped - 8 lines]
>
> Has anyone run across this before?  Any ideas to avoid it?

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

George Nicholson - 16 Sep 2005 23:04 GMT
Interesting article, (pertaining to Excel 2002/XP prior to SP3).

Unfortunately, I've seen this behaviour (or something remarkably similar) in
Excel 2003 upon occasion....

Signature

George Nicholson

Remove 'Junk' from return address.

> The information in the following MSKB article may help you:
>
[quoted text clipped - 15 lines]
>>
>> Has anyone run across this before?  Any ideas to avoid it?
KB - 16 Sep 2005 23:40 GMT
Thanks for the link to the KB article . Looks like what I need.

Best,
Ken B

> The information in the following MSKB article may help you:
>
[quoted text clipped - 14 lines]
> >
> > Has anyone run across this before?  Any ideas to avoid it?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.