by Allen Wyatt
(last updated July 11, 2020)
Frank was having a problem with Excel not opening a workbook whenever he would double-click on it in Windows. Excel would start, but the workbook would not load, and Excel would report that it couldn't find the file that was double-clicked.
This sounds like a problem with the file associations in Windows. The first thing to try is to force Excel to reconstruct all the proper association information. You do that by following these steps:
"c:\Program Files\Microsoft Office\Office\Excel.exe" /regserver
Now try double-clicking on your workbook again. It should open as you expect. If it doesn't, try this:
Figure 1. The General tab of the Options dialog box.
If you still cannot double-click on a workbook to open it, try these steps:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2949) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
Before you have your macro open and read a file from disk, you'll want to check to make sure it is really there. Here's ...Discover More
If you import data into Excel that is created by other programs, you know that it can be bothersome to get your data ...Discover More
When working with multiple workbooks open, you may want a way to close them all with a single command. Here's the secret.Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.