Updating Pivot

  • Thread starter Thread starter Tomek
  • Start date Start date
T

Tomek

I have some pivot defined. I've changed the source data and refreshed my
pivot. The updated field is displayed as the last value in the pivot and
not in ascending order as previously.

Any ideas?
Thanks,
Tomek
 
To manually sort the field, select a cell in the column, and click the
Sort Ascending button on the Standard toolbar.

To automatically sort the field, double-click the field button in the
pivot table.
Click the Advanced button, choose an AutoSort option, click OK, click OK
 
Back
Top