ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   unlink a pivot table (https://www.excelbanter.com/excel-programming/320053-re-unlink-pivot-table.html)

Gary Brown[_5_]

unlink a pivot table
 
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

"Botinha" wrote:

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

Thanks

André Fonseca



All times are GMT +1. The time now is 03:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com