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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot ungrouping on refresh? 3
Pivot table filter list - listing irrelevant subcategorys 1
Referencing a pivot tables Grand Totals Column 1
Refresh order when refreshing all in a workbook 1
Pivot Table Page Break Refresh Problem 0
One pivot table cannot overlap another pivot issue. 1
Pivot Chart Data Labels Disappear 1
Pivot Refresh Error when calling Excel Macro from VB.NET program 0

Back
Top