There are instructions here for clearing old items from a PivotTable
dropdown list:

http://www.contextures.com/xlPivot04.html


jim314 wrote:
Thanks! That helped tremendously. But I have another problem. There's a
value that's in my row heading that should not be there (and I've verified
that it shouldn't be there--it was and then I deleted it). How do I remove
that header value?

"CarlosAntenna" wrote:


Right click on the pivot table field, choose Field Settings and check the
box for "Show items with no data".

Carlos

"jim314" wrote in message
...

I'm trying to create a pivot table with a fixed number of rows and

columns.

I want the same row and column headings to show up in the pivot table even

if

some of the categories don't have any values associated with them at that
particular time.

How can I do this?

Thanks in advance for your help,

Jim





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html