Excel 2007 - The connection for this PivotTable has been deleted

  • Thread starter Thread starter Michael
  • Start date Start date
M

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.
 
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)
 
Back
Top