Pivot Table Calculated Item - Now it's REALLY SLOW

Sleever · Mar 7th, 2002, 02:28 PM

thanks for the lead on the calculated items. I now have all the calculations I need, but I'm running into an issue with the speed of calculations when I make changes to the field.

Is there anyway to increase the speed? Also, is there a way to surpress the calculated item for specific months?

Mark W. · Mar 7th, 2002, 02:37 PM

> ...but I'm running into an issue with the speed of calculations when I make changes to the field.

Speed of calculations? Do you mean Refresh? What's the nature of your "changes to the field"? What field are you referring to?

> Is there anyway to increase the speed? Also, is there a way to surpress the calculated item for specific months?

No.

Sleever · Mar 12th, 2002, 02:20 PM

I'm speaking about the time it takes to refresh the calculated item in the pivot table. Is there anyway to increase the speed?

Mark W. · Mar 12th, 2002, 02:31 PM

How big is this PivotTable?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 02:28 PM	#1
Sleever New Member Join Date: Mar 2002 Posts: 5	thanks for the lead on the calculated items. I now have all the calculations I need, but I'm running into an issue with the speed of calculations when I make changes to the field. Is there anyway to increase the speed? Also, is there a way to surpress the calculated item for specific months?

Mar 7th, 2002, 02:37 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	> ...but I'm running into an issue with the speed of calculations when I make changes to the field. Speed of calculations? Do you mean Refresh? What's the nature of your "changes to the field"? What field are you referring to? > Is there anyway to increase the speed? Also, is there a way to surpress the calculated item for specific months? No.

Mar 12th, 2002, 02:20 PM	#3
Sleever New Member Join Date: Mar 2002 Posts: 5	I'm speaking about the time it takes to refresh the calculated item in the pivot table. Is there anyway to increase the speed?

Mar 12th, 2002, 02:31 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	How big is this PivotTable?