I have a file that a co-worker that is 20mb with out entering any data. He
used indirect for alot of his formulas. one of the tabs ranges from A8 to
AF348, almost every cell has a indirect formula in it.
an example of one of these fomulas is below (this is in almost every cell)
with some variation
=IF(INDIRECT(ADDRESS(D$2+3,12,,,"SymTypes"))="","" ,IF(INDIRECT(ADDRESS($AJ$16+($A332-1),$AK$16,,,$AL$16))=INDIRECT(ADDRESS(D$2+3,12,,," SymTypes")),1,""))
Is there a way to make this smaller by using a different formula or using
VB. I like this file but it is just to big I have one that got as big as 56mb
Any feedback will be welcome