Hi,
I think this is mechanics of excel iself, but this issue is very frustrating to me.
So the calculation mode is manual. But if I try to clear or replace to values (copy paste values only)
some colums that contains more sofisticated formulas it takes very long time to do this.
For instance formula like this: SUMIFS(JH$88:JH2809;$DC$88:$DC2809;$DC2810;$BD$88:$BD2809;$BD2810-1;$DD$88:$DD2809;$DD2810)
I understand there is a logical reason that calculation process takes 2-3 minutes after entering this kind of formula to large range of cells , but why copy => paste special (values) or clearcontents actions takes even longer (>10 min) for the same range even in manual calculation mode?
There are no worksheet_change macros nor the range has related dependents (althought in manual mode it should not matter).
p.s. I even tried it on completely empty workbook: entering the above mentioned formula lets say to a 10000 rows (but one column only!), then calculating everything (F9), and then trying to clear contents or paste special (values) in all the range with mentioned formulas. It takes time! (and even sound of CPU fan appears!) Althought to my mind it should not be time and resource consuming action, because no real calculations have to be done...
Have anybody ever faced simmilar problems and could there be any solution?
I think this is mechanics of excel iself, but this issue is very frustrating to me.
So the calculation mode is manual. But if I try to clear or replace to values (copy paste values only)
some colums that contains more sofisticated formulas it takes very long time to do this.
For instance formula like this: SUMIFS(JH$88:JH2809;$DC$88:$DC2809;$DC2810;$BD$88:$BD2809;$BD2810-1;$DD$88:$DD2809;$DD2810)
I understand there is a logical reason that calculation process takes 2-3 minutes after entering this kind of formula to large range of cells , but why copy => paste special (values) or clearcontents actions takes even longer (>10 min) for the same range even in manual calculation mode?
There are no worksheet_change macros nor the range has related dependents (althought in manual mode it should not matter).
p.s. I even tried it on completely empty workbook: entering the above mentioned formula lets say to a 10000 rows (but one column only!), then calculating everything (F9), and then trying to clear contents or paste special (values) in all the range with mentioned formulas. It takes time! (and even sound of CPU fan appears!) Althought to my mind it should not be time and resource consuming action, because no real calculations have to be done...
Have anybody ever faced simmilar problems and could there be any solution?
