View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Brown[_5_] Gary Brown[_5_] is offline
external usenet poster
 
Posts: 236
Default 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