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

A simple procedure for you to follow:

Save the file with only one sheet containing your data in A1:H9000 -
eg as name_1.xls

CTRL-drag the sheet tab to copy that sheet into the same workbook, and
save this as name_2.xls

CTRL-drag the sheet tab again to create a second copy - save as
name_3.xls

Do this several more times, each time saving the file as name_x.xls

Then you can look in Explorer at the size of the files and how the
size varies with 1, 2, 3 etc sheets added (you might need to select
detailed view in the folder).

Note that 1Gb is a theoretical maximum, and that Excel needs some of
that memory, so don't go too near it - I would suggest that a 100mb
file is big enough if you want something that is workable.

Don't forget to delete those extra files once you are done with them.

Hope this helps.

Pete

On Oct 27, 1:49 am, Eric wrote:
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

Thank you for your suggestions
The size of 1GB is not memory for the files size, which is for cell formula.
The file size could be 30 MB, but the cell formula could be more than 1 GB
memory.
Does anyone have any suggestions on this issue?
Thank for any suggestions
Eric

"Pete_UK" wrote:

A simple procedure for you to follow:

Save the file with only one sheet containing your data in A1:H9000 -
eg as name_1.xls

CTRL-drag the sheet tab to copy that sheet into the same workbook, and
save this as name_2.xls

CTRL-drag the sheet tab again to create a second copy - save as
name_3.xls

Do this several more times, each time saving the file as name_x.xls

Then you can look in Explorer at the size of the files and how the
size varies with 1, 2, 3 etc sheets added (you might need to select
detailed view in the folder).

Note that 1Gb is a theoretical maximum, and that Excel needs some of
that memory, so don't go too near it - I would suggest that a 100mb
file is big enough if you want something that is workable.

Don't forget to delete those extra files once you are done with them.

Hope this helps.

Pete

On Oct 27, 1:49 am, Eric wrote:
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