Hi,
I have to debug an application that was converted from Excel 97 directly to
Excel 2003. Everything works fine except for the pivot tables. They are not
valid anymore and I can't replace the fields because I get an error message
saying that the pivot table is not valid.
The Pivot tables are not created with code but a lot of code exists that
access them to validate the data or to calculate some other figures.
Will I have to delete the pivot tables and rebuild them all together or is
there a way to fix the problem by correcting the references to the original
data?
Thank you in advance.
--
Jac Tremblay