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