Error Opening Second Workbook, Take Two

by Allen Wyatt
(last updated May 14, 2014)

I recently featured a tip concerning an error message that may appear if you try to open a second Excel workbook by double-clicking on that workbook from within Windows. One thing I forgot to mention was that you can bypass the error condition completely if you make one small configuration change in Excel. Follow these steps:

  1. Choose Options from the Tools menu. Excel displays the Options dialog box.
  2. Make sure the General tab is displayed.
  3. Make sure the Ignore Other Applications check box is not selected.
  4. Click OK.

According to Excel's help system, if the Ignore Other Applications check box is selected, then Excel won't share DDE information with other applications. This isn't all, however--it also affects how Excel starts when you double-click on a workbook in Windows and you already have Excel open. If the option is cleared (as it should be), then Excel starts the new workbook in the current instance of Excel. If it is selected (as it may be), then Excel tries to open a second instance of itself, and you will see an error message if you have a Personal.xls file on your system.

If changing the Ignore Other Applications check box causes unforeseen problems in other ways you use Excel, then you might also consider converting your Personal.xls file to an add-in. (How to create add-ins has been covered in other issues of ExcelTips.) Add-ins are opened in a special status, akin to read-only, and can therefore be opened by more than one instance of Excel.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3015) applies to Microsoft Excel , 8, , 10, and .

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

Using Your Own File Extensions

Word uses the DOC file extension for regular documents. If you want to use a different file extension, you can easily do so ...

Discover More

Searching Comments

Need to find that misplaced comment in your worksheet? It's easy to do using the Find and Replace capabilities of Excel.

Discover More

Sharing Headings with Others

Headings form the outline of your document and hopefully give it an easy-to-follow organization. If you want to share those ...

Discover More

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!

MORE EXCELTIPS (MENU)

Saving All Open Workbooks

Wouldn't it be nice to have a single command that would save each of you open workbooks, all at once? It's easy to do with ...

Discover More

Importing Huge Data Files

Sometimes, when importing data created by other programs, you may find that there is too much for Excel to handle. Here?s how ...

Discover More

Comma-Delimited and MS-DOS CSV Variations

Excel provides different file formats you can use to export your worksheet information. One such file format is CSV, or comma ...

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 for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)