ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help - Pivot Table Discarded (https://www.excelbanter.com/excel-discussion-misc-queries/113160-help-pivot-table-discarded.html)

Adrienne

Help - Pivot Table Discarded
 
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.

Debra Dalgleish

Help - Pivot Table Discarded
 
Perhaps the information in the following MSKB article will help:

"Unable to read file" error message when you open Excel file that
contains a PivotTable report
http://support.microsoft.com/default.aspx?id=819853

Adrienne wrote:
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.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 08:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com