Prevent refresh in certainpivot tables in workbook

  • Thread starter Thread starter Pierre
  • Start date Start date
P

Pierre

Can I selectively freeze, and refresh multiple pivot tables on a
worksheet, based on the same source data?

I didn't think so, but maybe someone has a good mousetrap to
accomplish this.
Pierre
 
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.
 
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.
Click to expand...

Thats very clever. Thank you Herbert. I'll have a gander at it.

Pierre
 
Back
Top