[SOLVED] unlink a pivot table

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
>