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
[email protected]HIS


"Michael" <[email protected]> wrote in message
news:[email protected]...
> 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.
>