Two pivot tables from one source

Hello,

I am having difficulty with a pivot table issue. I have created one pivot from the source data that I am happy with, and do not wish to change.

The source data is brought into Excel via ODBC.

I am now trying to create a separate pivot from the same table, in the same workbook, but on a different page.

When I modify the second table, the layout of the first changes.

 

Where to I goI to 'unlink' the definitions?

 

I have tried creating fresh pivot tables from the same source sheet, but they still link.

 

Any assistance appreciated.

 

I know I could use separate workbooks, but would really like just the one workbook,

 

Comments
There are 5 comments. Login or register to view them.

In Excel 2007, yes if you

Cantona1 |

Thanks - probably not a clear original post

tom123 |

Pivot Table

Ditta |

If you are getting the data via ODBC

Richard Willis |
Richard Willis's picture

Here is the solution I found

tom123 |