I get a table A1:Z60000 with formula, and make 10 copies for this file.
The purpose is to split the table into 10 parts for each file in order not
to hit the limitation of cell formula memory 1GB for office 2003. When I try
to remove part of table for the first file by deleting a portion of table, it
runs quickly and the file size is 10MB, but when I try to remove the part of
the table for the third file, it run slowly and the file size is 15 MB. Both
files are same, but I get different results on my handling process. Does
anyone have any suggestions on the cause for delay and for increasing the
file size?
Thanks in advance for any suggestions
Eric