Here are some sources of information.

http://support.microsoft.com/?kbid=211517
XL2000: Limits of PivotTables in Microsoft Excel 2000

http://support.microsoft.com/?kbid=157486
XL97: Limits of PivotTables in Microsoft Excel 97

http://support.microsoft.com/?kbid=157488
XL97: Using Server Page Fields in PivotTables

http://support.microsoft.com/?kbid=162476
XL97: Purpose of the PivotTable Optimize Memory Option

http://support.microsoft.com/?kbid=104308
XL: Optimizing PivotTable Performance

http://support.microsoft.com/?kbid=110343
XL: PivotTable Source Changes From Another PivotTable

--
Regards,
Tom Ogilvy


Terence wrote in message
...
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