Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct() usage
Now that I understand the Subject formula I use it extensively and in
particular projects Bringing back multi-criteria data between sheets. The issue I seem to be having is that after I create 3 or 4 sheets where there are maybe 2,000 or 4,000 rows using the Sumproduct() many "things" begin to happen. Recalc time being the first, resorting to Manual Re-calc mode; But now I seem to be having problems doing the normal File Save function. Has anyone experienced this situation? Are there no-no's involved in what I've done? More important is there a remedy, apart from a total abandonment of the functions usage? Thanks in Advance, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Errors in Sumproduct Usage | Excel Worksheet Functions | |||
100% cpu usage | Excel Discussion (Misc queries) | |||
How to project usage. | Excel Worksheet Functions | |||
Cursor Usage | Excel Discussion (Misc queries) | |||
HOW MANY 'IF CONDITIONS' CAN BE USED IN ONE SUCH USAGE? | Excel Worksheet Functions |