Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2007

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

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

Excel tip:

Apply Autosum with keyboard shortcut

If you press Alt and = at the same time, it applies autosum.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.