I have created a very large excel file that takes at least 1.5 minutes to open and .5 minutes to calcuate when refreshing using macros.
I am looking for help to reduce the size of the file which will help me to be able to access it more frequently since it takes over and freezes all other excel files and makes the entire computer run slowly.
My spead sheet is approx 330,000 MB. Not sure if I can even send that large of a file through the internet so I have not attached a link or the file on this page.
I have created an allocation system. In short, I am tying in open component purchase orders, with current inventory and running them against our production schedule to determine the date the components will be available by sales order.
The major constraints are that we have multiple sales orders that can produce using the same component on multiple lines on the same day.
To be short, the main table which uses the most memory contains the following formulas:
INDEX
IF
VLOOKUP
OR
ISNA
CONCATENATE
SUM
I use the same formulas for each part number. There are 260 parts. The primary fomula totals all the previous usages for the same component and compares it to the daily inventory.
Which is 159 columns x 152 rows per part.
Bookmarks