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?