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 » microsoft excel training - Pivot tables
microsoft excel training - Pivot tables
Resolved · Low Priority · Version Standard
Robert has attended:
Excel Advanced course
Pivot tables
Can we use unlimited variables in a pivot table
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
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:Paste a web address into the hyperlink address fieldIf you copy a web address the only way to paste into the address field of the hyperlink box is to use CTRL + V. Right click paste does not work. |