Prevent refresh in certainpivot tables in workbook
Excel 2007
If multiple PTs have Table1 as a source,
convert Table1 to a range and give the table range,
including headers, multiple defined names, such as
ArrayA, ArrayB, etc. Assign these names to the different
PTs as data sources. This will also unlink the PTs for
grouping purposes.
After recreating Table1, the defined names will stay dynamic.
In the Name Manager, edit the names to ArrayX, ArrayY, etc.
When trying to refresh, "Reference not valid" will appear.
|