Folks,
I've expanded a really comprehensive financial model which includes tons of INDEX and MATCH formulas. I had no choice because the way the model was built by previous person, that seemed to be the right way to expand it for our purposes. However, the problem now is that the model takes forever to load....and i mean good 10-15 minutes to just load. I have another computer with an SSD and it loads much faster on it...say about 3-4 mins...is there anything i can do to make it load faster? What am i doing wrong here? I did not think that it would take this long to load even with so many array formulas. I have set the formulas to "manual" and even then wasn't able to resolve it.
HELP!!!
TIA!
Bookmarks