Unresponsive Excel when Double-Clicking a Workbook

Written by Allen Wyatt (last updated May 20, 2023)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021


1

Stuart frequently finds that upon trying to open a workbook by double-clicking on it in Windows Explorer, the CPU goes into overdrive and he has to wait several minutes before Excel becomes responsive. This doesn't happen when he opens the workbook from within Excel. Stuart wonders why this occurs and how to stop it.

There are a few possible reasons for this, and none of them have anything to do with your workbook. I say this because Stuart indicated that the exact same workbook opens just fine from within Excel—it is only when opening it from Windows that things bog down. So ideas about potential workbook corruption, size, or complexity aren't borne out by this behavior.

So, that means that the problem is either with Windows or with something in your system. The first thing to check related to Windows is whether Windows Explorer is configured to show a preview of anything selected within it. (Previews appear at the right side of the Explorer window.) If so, opening a workbook through Explorer needs to accomplish three things:

  1. Open the workbook to display the preview in Explorer
  2. Start Excel
  3. Open the workbook within Excel

Notice that there are two separate openings of the workbook that may have to occur—one by Explorer and one by Excel. This means twice as much work. And, if your system is like mine, I cannot even double-click on a workbook in Explorer until such point as the preview is being displayed in the Explorer window. That can result in quite a slowdown in opening workbooks!

If you have the Explorer previews turned off and it still takes inordinately long to open the workbook, then you'll need to consider what may be happening with your system. It is possible that there is a problem with your hard drive or with your installation of Excel. For instance, Excel could be stored on your hard drive in a place where the disk sectors have some errors, and it takes Windows longer to load the program. You can figure out if this is the problem or not by simply starting Excel without double-clicking on a workbook. If it opens quickly, then chances are good it is not a system-related issue.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (13046) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Underlining Quoted Text

Do you have a document in which you need to convert all the quoted text (text surrounded by quotes) to underlined text? ...

Discover More

Easy Filtering Specifications for a PivotTable

When you want to include specific records from a source table into a PivotTable, you need to employ some sort of ...

Discover More

Hiding Table Rows on a Printout

When you work with tables in your document, you may want to hide some of rows in those tables so that they don't print ...

Discover More

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!

More ExcelTips (ribbon)

Excel Not Responding

Have you ever been working with data in Excel and experienced a "freeze" where the program stops responding? This can be ...

Discover More

Limiting Where a Workbook is Used

Want to limit who can use your workbook and on what system? Locking down a workbook can be trickier than you might imagine.

Discover More

Needing to Save a Workbook Twice

If you save a workbook and then immediately close the workbook, Excel may ask you to save again. This tip looks at ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 3 + 4?

2023-05-22 10:43:25

Willa Bundy

Thanks for this tip, Allen. I've been wondering why I kept having trouble opening a document. It's good to know the possible causes and how to open a document easier in Excel.


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.