I've tried finding a solution to this but to no avail!
I have a rather large data source which is defined and is the source to multiple pivot tables in a report.
Each pivot table has one style number selected - everything else is unchecked.
I recently added new data to the source and turns out some new style numbers are in the source...so when I refresh my pivot tables - these new style numbers that were never unselected (because they were never in the data source) are now appearing in my pivot tables.
I have found ways to include new data in a pivot table - but is there a way to PREVENT new data from appearing in a pivot table if it's already filtered?
I cannot find an answer to this anywhere...please be aware that I am still on Excel 2003 - another challenge!
Thank you!
I have a rather large data source which is defined and is the source to multiple pivot tables in a report.
Each pivot table has one style number selected - everything else is unchecked.
I recently added new data to the source and turns out some new style numbers are in the source...so when I refresh my pivot tables - these new style numbers that were never unselected (because they were never in the data source) are now appearing in my pivot tables.
I have found ways to include new data in a pivot table - but is there a way to PREVENT new data from appearing in a pivot table if it's already filtered?
I cannot find an answer to this anywhere...please be aware that I am still on Excel 2003 - another challenge!
Thank you!
