ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Error (https://www.excelbanter.com/excel-discussion-misc-queries/33693-pivot-table-error.html)

Maral

Pivot Table Error
 
Hello, I am getting the following error when trying to refresh a pivot table.
Can someone please let me know why this is? I was able to pivot a large
table before. Is there a limit to this?

Also, what are "column fields"?


"Microsoft Excel cannot make this change because there are too many row or
column items. Drag at least one row or column field off the PivotTable, or
to the page position."

Regards



Nick Hodge

Maral

No need to post to multiple groups. Most regular contributors read all. I
tried and answer in crashesgpfs...try there

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Maral" wrote in message
...
Hello, I am getting the following error when trying to refresh a pivot
table.
Can someone please let me know why this is? I was able to pivot a large
table before. Is there a limit to this?

Also, what are "column fields"?


"Microsoft Excel cannot make this change because there are too many row or
column items. Drag at least one row or column field off the PivotTable,
or
to the page position."

Regards






All times are GMT +1. The time now is 04:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com