Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to minimize the formula cell memory?
Does anyone have any suggestions on how to minimize the formul cell memory?
I get a table 10 columns x 5000 rows with given the same condition for each cell. Such as in cell AA1 = if($A1="","",B1*C1+D1), based on this given formula copy it down from AA1 to AJ1, and then copy the cell from AA1-AJ1 to AA5000-AJ5000. It seems to take too much formula cell memory on this table, does anyone have any suggestions on how to performance the same tasks with less formula cell memory? Thanks in advance for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to measure how much cell formula memory to be used? | Excel Discussion (Misc queries) | |||
How to save the cell formula memory on worksheet? | Excel Discussion (Misc queries) | |||
What is the limitation of formula memory for Office XP - Excel XP? | Excel Discussion (Misc queries) | |||
Delete cell memory | Excel Discussion (Misc queries) | |||
how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit | Excel Worksheet Functions |