View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge
 
Posts: n/a
Default Excel 2007 - The connection for this PivotTable has been deleted

Michael

Under the Data tabmanage connections chunkconnections 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 tableoptions tabdata
chunkchange data source itemdefinition tab on dialog and change the file
of the connection string

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Michael" wrote in message
...
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.