Multiple pivot tables, based on same source data tab; disable refreshon 1st tab?

P

Pierre

Have created a PT based on the input from a source data tab.
Now, I've duplicated the PT onto an additional tab, with the hope that
I can enter different dates for retrieval onto the source data tab,
and it would not refresh the first data tab containing the original
results when tab 2 is refreshed.
Is there a way to disable the first PT from refreshing (without copy/
paste/values) when the 2nd PT is commanded to get the new source data
by refreshing that tab?

Pierre
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retain pivot table formatting after refreshing data 0
Refreshing some Pivot Tables makes Excel stop or crash 0
Refreshing some Pivots Tables makes Excel stop or crash 0
Multiple Tables and Multiple Pivot Tables Help 0
Pulling data from one tab to another & matching it 0
Pivot Table Refresh 1
Need to add rows to entire wksht that includes a pivot table 0
Pivot table data source 1

Top