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:
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 .
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!
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
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
Excel provides different file formats you can use to export your worksheet information. One such file format is CSV, or comma ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."