Out of Object Memory Issue

[#1]

I'm using 8.5

I've unchecked "Ignore Calculation Limits".

For one and only one of my chart I've made a memory restriction for 1G

I have on the same sheet some text objects with some formulas with set analysis which based on current selection.

When the "Out of Object Memory" event happens on the chart, all of these text object formulas just brake the calculations.

If I'm removing the memory restriction everything works fine but with huge spikes.

Is there any way to make memory restriction for only one chart with keeping all normal functionality for all other objects on a sheet?

Thanks in advance for answers

[#2 · Accepted solution]

Ok. Forget about it. I've just changed "Calculated Formulas" from 1M to 5M

Everything is working now.

[Anonymous]

hi Currently i am using version 11.20 SR1 , where can i see the calculated formulas option.