Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivot table discarded to due to integrity problems 2

Status
Not open for further replies.

Trusts

Programmer
Feb 23, 2005
268
US
Hi,

I have a client with a mid-sized workbook. On one page is a pivot table. Occasionally, upon opening the workbook an error 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
 
If the data is coming across a network, I would suspect the network connection.

Frank kegley
 
No, it is simply the one open workbook sitting on the local hard drive.
 
Ken -

Thanks. This KB article looks helpful!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top