MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot tables and old data values

Posted by Vincent on February 07, 2002 8:29 AM

When you refresh data in pivot tables the previous values that once populated the field lists will show up in the show hide portion of the field properties window any ideas on how to clear these values out.?


Posted by Mark W. on February 07, 2002 8:37 AM

You'll have to re-create your PivotTable [nt]