T
Terence
Hi,
I have written a macro to get data from SQL server and put
the data in a Pivot Table. There are 7 row fields in the
pivot table.
After the pivot table is generated, I tried to do some
operations such as swapping the row and column fields,
choose members in the row fields,..,etc. Whenever I do
anyting in the Pivot Table, there is an error
message "Microsoft Excel cannot make this change because
there are too many row or column items. Drag at least on
row or column field off the PivotTable, or to the page
position. Alternatively, right click a field, andthen
click Hide or Hide Levels on the shortcut menu."
However, I followed the above instruction but the same
error message appear again. Therefore, I cannot do anyting
in the Pivot Table.
Can anyone help? Thanks a lot!
Terence
I have written a macro to get data from SQL server and put
the data in a Pivot Table. There are 7 row fields in the
pivot table.
After the pivot table is generated, I tried to do some
operations such as swapping the row and column fields,
choose members in the row fields,..,etc. Whenever I do
anyting in the Pivot Table, there is an error
message "Microsoft Excel cannot make this change because
there are too many row or column items. Drag at least on
row or column field off the PivotTable, or to the page
position. Alternatively, right click a field, andthen
click Hide or Hide Levels on the shortcut menu."
However, I followed the above instruction but the same
error message appear again. Therefore, I cannot do anyting
in the Pivot Table.
Can anyone help? Thanks a lot!
Terence