View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to save the cell formula memory on worksheet?

Does anyone have any suggestions on how to save the cell formula memory on
worksheet?
There is a formula in cell E1, which is (A1+B1)^C1/D1+E2. I need to drag
this cell down to the row 50000. Therefore, there is a list of similar
formula across E1:E50000. It takes a lot of cell formula memory here, and
take a longer time for calculating each cells.
Does anyone have any suggestions on how to save on memory?
Thanks in advance for any suggestions
Eric