Pivot tables

Hi Kevin

Thank you for your question.

Have you tried clicking the Refresh button once you have sorted? There is a pivot table toolbar that will likely appear in your Excel window when you select a cell inside the pivot table area. If not go to View - Toolbars - PivotTable.

Then click the button with the red exclamation mark (the Refresh button).

I hope this works for you.
Amanda

Hi Kevin

I am trying to resolve this issue for you. to help me could you clarify the following for me please

1. Are you sorting the data in the original table, or in the pivot table?
2. How exactly are yoy carrying out the "screen updates"?

Regards

Stephen