Losing a pull-down choice after refreshing a pivot table

[WillysK5]

Hello all,

I have a worksheet with a couple of pivot tables on it. The Page Field is a date and I'm not using the Column Fields or Data Items. I'm just displaying Row Fields associated with whatever date is selected in the Page Field.

After selecting a cell within a pivot table and hitting the update button in the toolbar, the date I've selected from the Page Field, in only that pivot table, disappears from the choices in the pull-down menu for the Page Fields.

The weird thing is that it only disappears from the pull-down menu in the pivot table the selected cell was in. That date is still a choice in all the other pivot tables in that worksheet.

Can anyone tell me what's going on and how to fix it?

Thanks!

[WillysK5]

I think I figured it out. I believe it had to do with how Excel 'associates' a pivot table with another to save space. I didn't do that and it seems to work fine.

[WillysK5]

Well, that didn't work.

If anyone has a solution, I would love to know it!!

[VBA Noob]

If you want to clear old items then see if link helps

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

VBA Noob

[WillysK5]

AHA! That might be it!

I need to refresh the data in the pivot table before I insert that field.

Thanks!