Why Two Big Excel Files Slow Each Other Down (and Your Drop-Downs Crawl)
The one idea: Two large Excel workbooks open at once compete for the same memory and processing power, so everything lags, even drop-downs, even if each file runs fine on its own. If you’ve had two big Excel files open and noticed things crawl, you’re not imagining it. Brokers lean on Excel for quoting (the … Read more