98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables
Pivot tables
Resolved · Low Priority · Version 2003
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Sorting List SubtotalsIf you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows. |