pivot table help!

[krscoffin]

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!!!



------------------------------------------------




------------------------------------------------

 

[Dave Peterson]

Debra Dalgleish has posted this macro a couple of times:

http://groups.google.com/[email protected]

And if you're new to macros, you can read some notes at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/getstarted.htm