98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » EXcel
EXcel
Resolved · Medium Priority · Version 2007
Mon 14 Nov 2011, 16:23Delegate Joanne said...
Joanne has attended:
Excel Advanced course
EXcel
What is the maximum amount of rows of source data which can be used to create a pivit table? I'm trying to create a pivot using almost 60,000 rows of source data and get an error massage saying that there are too many unique items. Thanks
Thu 17 Nov 2011, 11:13Trainer Paul said...
RE: EXcel
Hi, the limit used to be 8000 rows in 2003, I'll check to see if that has has changed in 2007 and come back to you later today.
Thanks
Paul
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:Random NumbersType =RAND()*200 to generate a number between 1 and 200. |
