K
ksc
I need some help with an issue I cannot seem to solve!
I have a pivot table in Excel that is based off of a data
input sheet. The data changes every month and the pivot
table is always linked to the specific data tab. When the
underlying data changes, the "old data" still displays as
options to check in the pivot table. The refresh option
does not seem to fix this, nor does the "Save data with
table layout" option.
I only want the options to check to be current data. For
example, my data sheet only has data for July and August,
but the pivot table has options to check for Jan - Aug.
Anyone have any idea how I can clear this old data out?
Thanks!!!
I have a pivot table in Excel that is based off of a data
input sheet. The data changes every month and the pivot
table is always linked to the specific data tab. When the
underlying data changes, the "old data" still displays as
options to check in the pivot table. The refresh option
does not seem to fix this, nor does the "Save data with
table layout" option.
I only want the options to check to be current data. For
example, my data sheet only has data for July and August,
but the pivot table has options to check for Jan - Aug.
Anyone have any idea how I can clear this old data out?
Thanks!!!