Pivot Table Error

  • Thread starter Thread starter runsrealfast
  • Start date Start date
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error Trying to add Calculated Items to a pivot table 1
One pivot table cannot overlap another pivot issue. 1
Excel Pivot Tables 4
Pivot tables - memory issues - please help 2
pivot tables 1
Pivot table - undo of a macro 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot table filter list - listing irrelevant subcategorys 1

Back
Top