Hello!
How could i unlink a pivot table from it data source?
Thanks
André Fonseca
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" <[email protected]> wrote in message
news:[email protected]...
> Hello!
> How could i unlink a pivot table from it data source?
>
> Thanks
>
> André Fonseca
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks