Calculating Cells

[jmersing]

I have a wowrkbook that has a few hundred sumproduct formulas in it. When I do certain things like cut a named range and move it somewhere else the file goes into "Calculating Cells" mode and takes about 10 seconds to complete. I'm thinking this is being caused by the sumproduct formlas, but I'm not sure.

Anyone have any advice on how to speed up these calculations other than turning auto calc on and off?

Thanks

 

[jmersing]

No Aladin just the sumifs

 

[Aladin Akyurek]

No Aladin just the sumifs

Perhaps this is now an issue of just the sheer number of formulas Excel has to evaluate.