[runsrealfast]

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

[joel]

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