Excel 2007 - The connection for this PivotTable has been deleted

[Michael]

Hello,

Using Excel 2007.

I deleted the connection for my PivotTable to a cube. How can I recreate and
reconnect that connection to my Pivot table?

Thanks.

 

[Nick Hodge]

Michael

Under the Data tab>manage connections chunk>connections option and add it
back, be sure to name it the same or the pivot table will not pick it up.
If you set it up with a different name, on the pivot table>options tab>data
chunk>change data source item>definition tab on dialog and change the file
of the connection string

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)