Home |
Search |
Today's Posts |
#1
|
|||
|
|||
large sumproducts causing memory errors
Has anyone experienced problems while using sumproducts
which cover large arrays, lets say a few thousand lines, in an exterior workbook? More specifically, I'm using sumproduct in spreadsheet 1... =sumproduct(--([array in spdsht 2]=[reference in spdsht 1]),--([same as first ex. for another qualifier]),--([sum array in spdsht 2])) Formula works correctly when spdsht2 is open. To my understanding(and some experience) the sumproduct link should be maintained with spreadsheets that are closed. When opening spreadsheet 1(without opening spreadsheet 2), I receive an error which says, "excel cannot complete this task with available resources. Choose less data or close other applications" The file still opens but the sumproduct result cells show N/A. After opening spdsht 2 the links correct themselves. With smaller ranges this has not been a problem. I dont think this has anything to do with other apps. Has anyone run into these apparent link limits with sumproduct? If so, are there any known solutions? thanks much to the excel superpowers, Dave PS. With even larger arrays or multiple spreadsheets which each have this issue, the problems seems to exponentiate, causing files to open without all their formatting. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not enough memory for large workbooks | Excel Discussion (Misc queries) |