unlink a pivot table

  • Thread starter Thread starter Botinha
  • Start date Start date
B

Botinha

Hello!
How could i unlink a pivot table from it data source?

Thanks

André Fonseca
 
Andre,

Copy and pastespecial values back over the values. But then it won't be a
pivot table anymore :-(

HTH,
Bernie
MS Excel MVP
 
Botinha,
To keep the pivot table as a pivot table...
Right-click inside the pivot table so that the popup menu appears.
Select 'Table Options...'.
Uncheck 'Save Data with Table Layout'.
Uncheck 'Enable Drilldown'.
Hope this helped,
Gary Brown
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error Message - Macro to Unlink MS Queries from Workbook 0
Cleaning pivot table links and references 1
Pivotcache 1
Unable to Group in Pivot Table 1
Pivot table multiple filters 2
Expand and collapse 2
How I can set dynamic pivot table ONLY when I have enough data point 1
How to add straight line from cell value in pivot table chart 1

Back
Top