{"id":4595,"date":"2011-03-10T11:23:16","date_gmt":"2011-03-10T19:23:16","guid":{"rendered":"http:\/\/www.perivision.net\/wordpress\/?p=4595"},"modified":"2013-02-06T15:11:52","modified_gmt":"2013-02-06T23:11:52","slug":"how-to-make-excel-open-each-file-in-a-separate-window-tip-198","status":"publish","type":"post","link":"https:\/\/www.perivision.net\/wordpress\/2011\/03\/how-to-make-excel-open-each-file-in-a-separate-window-tip-198\/","title":{"rendered":"How to make Excel open each file in a separate window. Tip #198"},"content":{"rendered":"

\"\"<\/a>As a developer and analyst, I heavily rely on the powerful features and flexibility that Microsoft Excel provides for various tasks. This was especially true when I was supporting enterprise level accounting systems. I would often be working with two or more workbooks at a time, and loved having the ability to view two worksheets at the same time using dual monitors.<\/p>\n

With the release of Excel 2007\/2010, this ability to open two separate instances of Excel is no longer as easy as double-clicking on an Excel Shortcut anymore. Microsoft has forced users to one MDI container for all their Excel windows. As far as I can tell, the primary benefit of being constrained to one MDI container is less memory usage and features specific to DDE<\/a>. Due to the nature of Excel and the numerous ways people use it, I think Microsoft was smart to make this the default behavior. However, their neglect in making this behavior optional, thereby forcing it on users, is unacceptable.<\/p>\n

The popular way to get around this problem is to disable DDE in Excel, allowing you to once again open new windows in separate instances of Excel. Unfortunately, this breaks some essential DDE specific features, such as being able to copy formulas between separate instances of Excel.<\/p>\n

Therefore, the best solution (for me) is to make opening a separate instance an option. Instead of double-left-clicking on the spreadsheet files, you will just use right-click and ‘Open in New Window’ whenever you wish to open a document in a completely new Excel instance.<\/p>\n

To accomplish this, you will be creating a new Action like ‘Open in New Window’ on your popup action menu (right click), and this action can be set to ignore DDE. This will allow you independently control how Excel opens supported files (XLS, XLSX, CSV, etc).<\/p>\n

The easiest way to do implement this is by following the instructions below:<\/p>\n

Note: I have only verified that these instructions work on Windows XP and Office 2007\/2010. If you try with different software, your results *may* vary.<\/em><\/p>\n

1.\u00a0\u00a0\u00a0\u00a0\u00a0 In Windows Explorer, go to Tools > Folder Options > File Types<\/p>\n

2.\u00a0\u00a0\u00a0\u00a0\u00a0 Scroll down to the XLS extension and click [Advanced]\n

3.\u00a0\u00a0\u00a0\u00a0\u00a0 Click on “Open” in the list to highlight it and then click [Edit]\n

4.\u00a0\u00a0\u00a0\u00a0\u00a0 Copy [CTRL-C] the Application Path contents to clipboard (or notepad)<\/p>\n