I have a large model over 5MB that appears to have trouble upon saving. It gets hung up at around 40% calculation and is very slow when I do try to Save. The file itself has a few macros in it and the INDEX/MATCH formulas through it's 10+ worsheets. Is going to be a problem with the efficiency of the file no matter what I do?
This tool has to get out to several people to use and it works great! if only they could get it to run quickly (or quicker).
Any thoughts? Would it help to turn off calculation and then let it save (I assume it automatically starts calculating when you hit save as well?)
Thanks,
Rhonda
This tool has to get out to several people to use and it works great! if only they could get it to run quickly (or quicker).
Any thoughts? Would it help to turn off calculation and then let it save (I assume it automatically starts calculating when you hit save as well?)
Thanks,
Rhonda