Pivot table - "...too many rows... error
 

well the code was working but then the boss wants another row field which
unfortunately
consists of two subrows.

anyways the first data column is added.
when the program attempts to add the second one i get:

"...cannot make this change because there are too many row or column items...


BUT i can do it manually and get no error.
any work around?

thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1

Pivot table - "...too many rows... error
 

well it did not work manually like i thought.
i had left out a row field.

BUT, i did find a solution.

i entered the data fields first, then the row fields and no problems

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1