Excel: Opening Two Instances Of Excel
Anyone that uses Excel regularly has most likely needed to compare two spreadsheets side by side. In older versions of Excel, there was an obvious setting, in Options, that would allow that to happen.
In the newer versions of Excel the setting still exists, but it is not very intuitive, nor obvious.
Here is how to do it: (See the Note below the image too, for a potential error you might see)
- Open Excel and click on the File menu option.
- Choose Options or Excel Options, depending on your version of Excel.
- Choose Advanced
- Scroll down until you see the General section
- Check the box labeled Ignore other applications that use Dynamic Data Exchange (DDE)
- Click the OK button
Now, whenever you open more than one instance of Excel, it will open it up in its own window, completely separate from the first instance!!