Transcription
So have you ever been in a situation where you try to double-click an Excel file, and it just doesn’t open? Watch this, if I double-click File2, nothing happens. You do see the wheel going in Windows, so it’s actually working, but nothing’s happening. What’s also puzzling about this is that if you check the task bar here, Excel’s not flashing, nothing’s flashing, it’s like nothing need my attention… so what gives?
Now to understand why this is happening, let’s click the Excel icon in the taskbar. So here you can see that I was already updating a file called File1.xlsx, and the file we were trying to open is actually File2. Now what’s interesting here is that there’s only one Excel window, if you check down here. There’s just one. Where’s File2, I double-clicked it twice, why is it not opening? Well here’s the story. If you’re in the middle of updating a formula in Excel, and then you minimize, go somewhere else, work on something else, and then try to open another file, Excel can’t do anything until you conclude what you’re doing here. If I go and I actually press the red X to cancel the formula, File2 appears.
So the next time you try to open an Excel file by double-clicking it, and you don’t understand why Excel is taking so long, check it out, it might actually be what I showed you.