Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Connection String - How to hide it? | Excel Discussion (Misc queries) | |||
Pivot chart loses data connection when copied to new workbook | Charts and Charting in Excel | |||
Pivot table loses its properties | Excel Discussion (Misc queries) | |||
always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
Copy pivot table and get rid of connection | Excel Discussion (Misc queries) |