This is based on a faulty memory, so you'll have to test it.

I _think_ you'll want to save the workbook as 97-2003 version before you build
the pivottable. Then (reopen???) and build the pivottable.



Jimmy G wrote:

I am running Office 2003, but I have been sent pivot tables created by a
colleague in Excel 2007. The workbook is being saved as an *.xls, but when I
try to click on the column headers in the pivot table, I get an error saying
"this Pivot Table Report is not Valid".

Does anyone have any suggestions how to address this issue?

--

Dave Peterson