Kevin has attended:
Access Intermediate course
Pivot tables
In a pivot table that i am using, i was able to sort the data quite easily via the "Data => Sort", but since I have manipulated it, when i try to sort the screen updates, but the pivot table does not sort.
Anyone have any ideas as to why?
RE: 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
RE: Pivot tables
Hi Amanda,
Thanks for your reply, unfortunately refreshing the data doesn't resolve the issue.
Any other ideas?
Thanks
Kevin
RE: Pivot tables
Hi Kevin
I don't have any other suggestions but I will ask one of my other colleagues to have a look at your question.
Kind regards
Amanda
RE: Pivot tables
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
