Problem with Pivot Tables


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

Hello,

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

Thanks.

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.