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.?

thanks
Vincent


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

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