Hi,

Trying to do a simple pivot table, with 6 columns based off data with
30 columns and 7000 rows, but for some reason when i press finish on
the pivot wizard i get the below message :

"Microsoft Excel cannot make this change because there are too many
rows or column items. Drag at least one row or column field off the
pivot table or to page position. Alternativel, right click a field,
and then click Hide or Hide levels on the shortcut menu"

Normally the tables are easy to make, but for some reason this just
isn't working. I've tried taking out columns but it still doesn't
work.

Any ideas?

Thanks


--
sam1
------------------------------------------------------------------------
sam1's Profile: http://www.excelforum.com/member.php...o&userid=18280
View this thread: http://www.excelforum.com/showthread...hreadid=345570