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 Stella quote spreadsheet included), so this comes up a lot.
What’s actually happening
An open workbook isn’t passive. It loads into memory and actively uses system resources. Open a second large workbook and both compete for the same limited RAM and CPU. When RAM runs short, your computer falls back on slower storage-based memory, which immediately drags performance. Meanwhile Excel keeps running background calculations in both files at once, splitting your processor’s attention.
Why everything feels slower
It’s not just big calculations. Scrolling gets less responsive, typing lags slightly, switching tabs takes longer. Excel is juggling everything across both workbooks, not just the action you’re taking.
Why drop-downs lag specifically
A drop-down looks simple, but Excel often has to evaluate and prepare the list before showing it. In a large file that’s real work, and when the system is already loaded, your click waits in line for processing power. So you click, pause, and then it finally opens.
Why it happens even if each file is fine alone
Each workbook may run perfectly by itself. The problem is total system load, not the file. Add a second heavy file and you cross a threshold where performance degrades, which is why it feels inconsistent: fine some days, sluggish others, depending on what else is running.
What to do about it
Work in one heavy workbook at a time and close the other when you don’t need it. If you must keep both open, set Excel’s calculation to Manual (Formulas, then Calculation Options, then Manual) so it isn’t constantly recalculating both, and press F9 to recalc when needed. More RAM helps if this is a daily reality.
Why it matters to you
Quoting season is slow enough without fighting your spreadsheet. Knowing this is a resource issue, not a broken file, saves you from chasing phantom problems and keeps you moving when you’re heads-down in a quote.
Key takeaways
- Two large workbooks compete for the same RAM and CPU, so both slow down.
- Drop-downs lag because Excel must prepare the list while waiting on busy resources.
- Each file can be fine alone; it’s the combined load that bites.
- Fixes: work one at a time, set calculation to Manual, or add RAM.
Check yourself
Your Stella quote file runs fine alone but crawls when a big census workbook is also open. Is the Stella file broken?
No. It’s a system-load issue: both large files are competing for memory and CPU. Close the census file (or set calculation to Manual) and speed returns.