Pivot Table Error-what are "column fields"?

[Maral]

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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Maral" <Maral@discussions.microsoft.com> wrote in message
news:ED7B3E79-676A-4B4A-8798-96F393CD8F23@microsoft.com...
> 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
>
>