From: runsrealfast on


While trying to add a calculated item to a pivot table I get the
following error

"The item cannot be added or modified. There may not be enough memory,
the maximum number of items allowed in a field may have been reached,
or if a Visual Basic macro is performing the operation, the macro may
be incorrect

Simply the Pivot Table or check the macro for errors, and then try the
operation again."

I am doing this manual so the macro issue is not the problem. It must
be the memory issue, but how do I know how much memory is being used.
The workbook has about 7 pivot tables in it and it's a smaller version
of the same file and therefore is using less memory (which is the
point of recreating the old file). How do I find out if it's the
memory issue. Also my pivots all pull off the same data.

John

From: Joel on
I would think you are exceeeding the number of items in a field rather than
the memory issue. I would get the count number from the pivot table and see
how many entries you have.

"runsrealfast" wrote:

>
>
> While trying to add a calculated item to a pivot table I get the
> following error
>
> "The item cannot be added or modified. There may not be enough memory,
> the maximum number of items allowed in a field may have been reached,
> or if a Visual Basic macro is performing the operation, the macro may
> be incorrect
>
> Simply the Pivot Table or check the macro for errors, and then try the
> operation again."
>
> I am doing this manual so the macro issue is not the problem. It must
> be the memory issue, but how do I know how much memory is being used.
> The workbook has about 7 pivot tables in it and it's a smaller version
> of the same file and therefore is using less memory (which is the
> point of recreating the old file). How do I find out if it's the
> memory issue. Also my pivots all pull off the same data.
>
> John
>
>