Page 1 of 1
R&R11 Xbasew pivot table limitation
Posted: Tue Apr 25, 2006 9:27 am
by pbla1_wcc
I^m trying to create a pivot table with 30 rows, but R&R11 only seems to let me have 24. I can add the extra row definitions and the query runs with no error message, but only 24 rows show up in Excel. If I delete 6 other rows then the new ones at the bottom show up!____I couldn^t find anything in the documentation about limits. Has anyone hit the same problem?
=> R&R11 Xbase pivot table limitation
Posted: Wed Apr 26, 2006 4:35 am
by kfleming
This is not one that I am aware of.____I will have a look to see if I can reproduce this.____Kathleen__R&R Support
==> RE: R&R11 Xbase pivot table limit
Posted: Wed May 10, 2006 4:53 am
by pbla1_wcc
Additional info:__What I^m trying to do means that I have one column field, one row field and 28 values to be summed. This works in Excel2000, but in the R&R pivot table I can^t get more than 24 value fields.____Peter__
===> RE: R&R11 Xbase pivot table limit
Posted: Wed May 10, 2006 10:40 am
by kfleming
I tested back to V8 of R&R and it does seem that the limit to the number of Pivot Export values is indeed 24. I will add this to the bug list but it will have a fairly low priority since you are the first user to encounter this.____Kathleen__R&R Support