Excel 2003 Pivot table corruption, Can I detect this?

P

Philippe Cand

Hello,
It happen from time to time that a pivot table gets corrupted.
This may happen because of VBA code or for some other reason.
Both Pivot tables and Pivot cubes can be affected.
The corruption may or may not be visible. It depends what you are doing.
If you open a 03 pivot with Excel 2007, xl07 will detect corrupted pivots
and discard them. Unfortunately I cannot use xl07 in a production
environement.
My question is;
Is there a way with Excel 2003 to detect corrupted pivot tables?
I need to provide my users with a way to check their pivot tables.
Thanks,
Philippe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Pivot table report invalid 0
Pivot table Days to Months 0
2nd Pivot Table on Worksheet Crahes Excel 1
Consolidate Pivot Tables/Cache using Excel 2003 1
Excel 2007 pivot table using analysis services cube as data source 0
Excel 2010 Slicer Connection / Pivot Table Problem 3
How do I locate overlapping pivot table reports in Excel 2003? 1

Top