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 |
All times are GMT +1. The time now is 02:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com