Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Error
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Error
The number of items allowed depends on the version of Excel that you're
using. There's information on the pivot table limits he Limits of PivotTables in Excel (Excel 97 - 2000) http://support.microsoft.com/default.aspx?id=211517 Description of the limits of PivotTable reports in Excel (2002-2003) http://support.microsoft.com/default.aspx?id=820742 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table #DIV/0! Error | Excel Discussion (Misc queries) | |||
Pivot table error | Excel Discussion (Misc queries) | |||
Pivot table error | Excel Worksheet Functions | |||
Pivot Table Error | Excel Discussion (Misc queries) | |||
Pivot table error | Excel Discussion (Misc queries) |