If you’ve ever had two large Excel workbooks open at the same time and noticed things starting to lag, you’re not imagining it. Files that normally run smoothly can suddenly feel sluggish, and even simple actions like opening a drop-down can take longer than expected. Since most brokers rely heavily on Excel when preparing quotes for clients, and many are working with larger, more complex spreadsheets, this comes up more often than you might think. In fact, if you’re using tools like the Stella quote spreadsheet, you may run into this exact issue, so it’s worth understanding what’s going on behind the scenes.
What’s Actually Happening
When you open an Excel workbook, it doesn’t just sit there passively. It loads into your computer’s memory and actively uses system resources. When you open a second large workbook, both files are now competing for the same limited resources.
The two biggest factors at play are memory and processing power. Each workbook consumes RAM, and if both are large, your system can start to run short. When that happens, your computer compensates by using slower storage-based memory, which immediately impacts performance.
At the same time, Excel is constantly performing background calculations. Even if you’re only working in one file, both workbooks may still be recalculating formulas, updating totals, or refreshing internal logic. That shared workload gets split across your CPU, which slows down how quickly anything happens.
Why Everything Feels Slower
The slowdown doesn’t just show up in big calculations. It shows up in everyday actions.
Scrolling can feel less responsive. Entering data may have a slight delay. Switching between tabs can take longer than usual. These small delays add up and make the entire experience feel clunky.
That’s because Excel is not prioritizing just the action you’re taking. It’s juggling everything happening across both open workbooks at the same time.
Why Drop-Downs Start Lagging
One of the most noticeable symptoms is when drop-down lists become slow to open.
At first glance, a drop-down seems simple. You click it, and a list appears. But behind the scenes, Excel often has to process and prepare that list before displaying it. In a large workbook, that can involve evaluating a sizable set of data.
When your system is already under load from multiple open workbooks, even that small task gets delayed. Excel has to wait for available processing power before it can respond to your click.
The result is that the drop-down doesn’t open instantly. You click, pause, and then it finally appears. The larger and more complex the file, the more noticeable that delay becomes.
Why This Happens Even If Each File Works Fine Alone
A key point here is that each workbook may perform perfectly on its own. You can open one file and everything runs smoothly. The issue only shows up when both are open together.
That’s because the limitation is not the file itself, but the total load on your system. Each file adds to the overall demand, and once you cross a certain threshold, performance starts to degrade.
This is why the problem can feel inconsistent. Some days it works fine, and other times it slows down, depending on what else is running and how much memory is available.
The Simplest Way to Think About It
A good way to think about this is that Excel is sharing a fixed pool of resources. One large workbook uses a big portion of that pool. Two large workbooks can push it close to the limit.
Once you get near that limit, everything slows down. Not just calculations, but basic interactions like clicking, typing, and opening drop-downs.
Final Thought
If you’re noticing lag, especially with things like drop-down lists, it’s often not a problem with the file itself. It’s a sign that your system is being asked to handle more than it comfortably can at one time.
Understanding that can save a lot of frustration. Instead of chasing a problem inside the spreadsheet, you can recognize that it’s simply the result of running multiple heavy workbooks at once.