Copy pivottable, change connection properties in copied pivottable and first pivottable is also changed
Posted on 2010-03-23
We want to build a workbook with different pivottabels. All pivottables are connected to the same oracle-database, but have all a small difference in their connection property SQL-Query
The easiest way in this case is to copy the pivottable and edit the Query. When we do that, however, the changes are also implemented in the source-pivottable.
How come and how can we work around for this ?