Two pivot tables from one source | AccountingWEB

Two pivot tables from one source


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,


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 |