ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table loses Data Connection (https://www.excelbanter.com/excel-discussion-misc-queries/236075-pivot-table-loses-data-connection.html)

Dead.Zone

Pivot Table loses Data Connection
 
Hello,

Yesterday, I created a pivot table, using a Data Connection to an external
data source. At the end of the day, I saved my work and shut down. Today,
when I open the workbook, the spreadsheets all look the same, but the cells
that make up the pivot tables don't pull up the options panes when I make
them the active cells. And if I double-click on one of the cell sin the
pivot table, I get the following error:

The connection for theis PivotTable has been deleted.

Well, if I open up the connections dialog, the connection is listed there.
But the pivot table seems to think that its connection is missing. So... How
do I reattach the pivot table to the connection? I can't seem to get into
the pivot table's 'options' dialog. In fact, except for that single error
message, Excel doesn't seem to recognize my pivot table as a PivotTable, at
all.

Thanks,
Scott


All times are GMT +1. The time now is 01:33 AM.

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