Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Pivot tables
|
|
|
The UK's most regular 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. |
microsoft excel training - Pivot tables
Resolved · Low Priority · Version Standard
Reply Wed 12 Dec 2007, 15:46Delegate Robert said...
Robert has attended:
Excel Advanced course
Pivot tables
Can we use unlimited variables in a pivot table
For upcoming training course dates see: Pricing & availability
RE: Pivot tables
Dear Robert
I assume by Variables you mean the fields you can have going across!!
If that was your question then the answer is that adding Filed columns going accross make your file larger than adding the rows going down. WHY? Please don't ask me why!
After a certain no. of columns in your Pivot you start getting an error about "Not enough memory to display pivot table"!!
It also depends on the RAM and the hard disk space of your computer.
It is generally recommended that you limit the no. of column to three or four because of the above mentioned reason about teh memory.
I hope this has helped!! If you had a more specific query then please post that may be either by giving example or uploading your file WITHOUT ANY CONFIDENTIAL INFO OF YOUR CUSTOMERS/SUPPLIERS OR COMPANY!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
|