software

I have a workbook which has several pivot charts and tables that pull
information from a single worksheet within the workbook. The quot;Row
Fieldquot; has dates and employee names. I have updated this through the
month of april, and decided to save a copy to use a template for each
new month. In the template I deleted all information in the source
sheet (except the column titles), refreshed the pivot tables and saved
it as a copy named quot;templatequot;.

I then went and pasted information for a previous month (March),
refreshed everything and it appears to work just fine.

Problem is encountered when I click on the quot;Fieldquot; button to filter
data. When the list is brought up of possible days or employees, the
entries for April are still listed. For example, I have an entry for
April 1, April 2.... and then the March 1, March 2.... entries appear.
Not sure why these show up, there are no April dates in the source data.
The field list seemed to have remembered all the original entries and
cannot drop them. This isn't that big of a problem, but it is strange
and I was wondering how I can prevent this.

I tried removing the quot;datequot; from the row field and then adding it back
in, but it still remembers the April dates...

Help?--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: www.excelforum.com/member.php...foamp;userid=7092
View this thread: www.excelforum.com/showthread...hreadid=535116To clear old items from the pivot table, you can use one of the
techniques shown he

www.contextures.com/xlPivot04.htmlshadestreet wrote:
gt; I have a workbook which has several pivot charts and tables that pull
gt; information from a single worksheet within the workbook. The quot;Row
gt; Fieldquot; has dates and employee names. I have updated this through the
gt; month of april, and decided to save a copy to use a template for each
gt; new month. In the template I deleted all information in the source
gt; sheet (except the column titles), refreshed the pivot tables and saved
gt; it as a copy named quot;templatequot;.
gt;
gt; I then went and pasted information for a previous month (March),
gt; refreshed everything and it appears to work just fine.
gt;
gt; Problem is encountered when I click on the quot;Fieldquot; button to filter
gt; data. When the list is brought up of possible days or employees, the
gt; entries for April are still listed. For example, I have an entry for
gt; April 1, April 2.... and then the March 1, March 2.... entries appear.
gt; Not sure why these show up, there are no April dates in the source data.
gt; The field list seemed to have remembered all the original entries and
gt; cannot drop them. This isn't that big of a problem, but it is strange
gt; and I was wondering how I can prevent this.
gt;
gt; I tried removing the quot;datequot; from the row field and then adding it back
gt; in, but it still remembers the April dates...
gt;
gt; Help?
gt;
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Debra, I have tried to manually clear the old items, but it doesn't
work. They still appear in my lists and I have checked the source data
to confirm they are removed completely.

I had to resort to using the macro you have on your site, which did the
trick for me (thankfully). Thanks, but why didnt the manual method
work?--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: www.excelforum.com/member.php...foamp;userid=7092
View this thread: www.excelforum.com/showthread...hreadid=535116If you manually grouped the items, ungroup them.
If there are multiple pivot tables that use the same pivot cache, remove
the field from all the pivot tables.
Then refresh the pivot table, and add the field.

shadestreet wrote:
gt; Debra, I have tried to manually clear the old items, but it doesn't
gt; work. They still appear in my lists and I have checked the source data
gt; to confirm they are removed completely.
gt;
gt; I had to resort to using the macro you have on your site, which did the
gt; trick for me (thankfully). Thanks, but why didnt the manual method
gt; work?
gt;
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html