View Single Post
  #1   Report Post  
Craig_Richards
 
Posts: n/a
Default pivot table error (25000 rows!!)


I am trying to run a pivot table on a file containing 25000 rows. I have
5 duplicate (identical structure) files. The pivot works on each but
one. On this file I get an error saying it has too many columns or rows
in the pivot table. Drag at least one column or row off the table...

Does anybody know what the reason for this message is, are their limits
to rows or columns? The identical table works on the other files,
therefore this message is so strange.

Who has an idea?


--
Craig_Richards
------------------------------------------------------------------------
Craig_Richards's Profile: http://www.excelforum.com/member.php...o&userid=21936
View this thread: http://www.excelforum.com/showthread...hreadid=484678