I've created pivot tables based on embedded data (data in a worksheet within
the same workbook) and external data (MS-Access). When I create pivot tables
based on either of these sources close the file and reopen I am getting the
following error
Errors were deteded in the file (my file name)

The following is a list of repairs:

PivotTable report of 'PivotTable7" on [filename].SheetName was discarded due
to integrity problems.

The data remains but has been converted to values. Please help me - I have
a deadline coming up and have been working on these reports for a few days.