MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Problem with Pivot Tables

Posted by Javier on February 14, 2002 3:56 AM


How can I update the content of the datalists used to filter a pivot table? It show deleted and unsorted datas.


PD: Sorry, but my english is very poor.

Posted by Don C on February 14, 2002 1:58 PM

With the cursor in a cell of the pivot table, start the PivotTable wizard and press <Back to the point where the data range is displayed. Don't change anything (unless you do need to change the range, of course) and click on Next> and Finish. Then recalculate the table.

The new entries should show up. Click on an entry header and sort it, either with the Tools/Sort menus or the sort icons.