Excel 2003 keeps destroying my Pivot Tables when a spreadsheet is loaded up.
I get the following message. "PivotTable ......was discarded due to integrity
problems".

An extract from Microsoft Office Excel File Repair Log 24 Oct 2005 reads
Errors were detected in file 'D:\Time Report Oct 2005.xls'

The following is a list of repairs:

PivotTable report 'PivotTable1' on '[Time Report Oct
2005.xls]HrsSummaryDaily' was discarded due to integrity problems.
I have had 10 Pivot Tables trashed by Excel.

I am running Office 2003 under Windows XP Professional.