Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
We're using a quite powerful machine: quad core extreme CPU, 4gb of Ram, XP
Pro. However, we're dealing with array formulas which refer to a worsheet of 205,000 rows * 23 columns (ever-increasing). Excel doesn't operate properly and on manual calculation, it shows the message: "Excel ran out of resources". Is there another way to calculate such large an amount of information? Another program that is? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Alternative to using 10 V-lookup formulas | Excel Worksheet Functions | |||
Returning an alternative value if lookup cannot be found in array | Excel Discussion (Misc queries) | |||
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
Using "--" as an array formula shortcut / alternative | Excel Discussion (Misc queries) | |||
Excel array formulas | Excel Discussion (Misc queries) |