Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 191
Default calculated item not allowed in pivot

I am trying to do a pretty standard calculated item in a pivot in '03.
Getting the error that "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 VB macro is performing the operation, the macro may be
incorrect."

I know I am not out of memory. It's a small data set, and the table has no
other calcs. I don't think VB is running, as I closed down and then
restarted, and don't think that I have any macros to run in this workbook. I
am not sure about field item limits, but I only have 11 different items in
this field (about 3,500 records total), so would be surprised if that gets to
the limit. Any assistance?

--
Boris
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table, IF function, calculated item versus calculated field NomadPurple Excel Discussion (Misc queries) 1 March 9th 10 03:17 PM
Calculated Field and Calculated Item in Pivot Table Fred Smith Excel Discussion (Misc queries) 0 March 4th 07 08:15 PM
pivot table formulas for calculated field or calculated item Vicky Excel Discussion (Misc queries) 3 June 6th 06 05:06 AM
Pivot Table Calculated Item SamBayer1957 Excel Discussion (Misc queries) 1 August 11th 05 10:27 PM
Pivot Table Calculated Item Erin Searfoss Excel Discussion (Misc queries) 2 February 9th 05 03:11 AM


All times are GMT +1. The time now is 03:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"