danovkos
05-03-2010, 04:16 AM
Hi all,
pls. is it possible to do following?
I have big wb with many sheets. In some of them i have sumproduct formulas, which always calculate (if is autocalculation turned on) with my huge data (6000 rows x 30 col). I think, thats ths reason, why it takes me a long time, if i want only to filter my huge data or so.
Because this i want to turned off recalculation for my sumproduct formula sheets. I will turned on only manualy with button. But whole wb will be calculating ad default (automaticaly)
How can i do that?
thx a lot.
pls. is it possible to do following?
I have big wb with many sheets. In some of them i have sumproduct formulas, which always calculate (if is autocalculation turned on) with my huge data (6000 rows x 30 col). I think, thats ths reason, why it takes me a long time, if i want only to filter my huge data or so.
Because this i want to turned off recalculation for my sumproduct formula sheets. I will turned on only manualy with button. But whole wb will be calculating ad default (automaticaly)
How can i do that?
thx a lot.