Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables
Barbara has attended:
Excel Advanced course
are there any restrictions to the amount of data I can use in one pivot table?
Hello Barbara
Thank you for your question and welcome to the forum.
Please see the link below to Microsoft's Knowledge Base article on pivot table limits for Excel 2003:
http://support.microsoft.com/kb/820742/
Kind regards
Amanda
Fri 3 Apr 2009: Automatically marked as resolved.
Primarily Excel is set up to sort data that is stored in columns rather than rows.
It is possible to get Excel to sort data stored in rows however.
Click in the row you want to sort, or select the cells in the rows you wish to sort.
Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
