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 measure how much cell formula memory to be used?

Does anyone have any suggestions on how to measure how much cell formula
memory to be used in worksheet?
I am using Office 2003, which is officially limited to 1 Gigabyte (GB) of
memory.
I get a worksheet with a lot of formula A1:HZ9000 and would like to split
this table into different worksheets in order to meet the limitation of 1 GB
memory for Office 2003.
Does anyone know any tools or rules to meaure the size of formula memory
within a given table? Therefore, I can determine the number of worksheets for
this table A1:HZ9000?
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric