I'd like to have a second instance of the same excel file opened in a new window. However, the second instance should be opened physically detached from the first, such that the screen shows two of the same file side-by-side. Functionally speaking, a modification made to one instance will be reflected to the other in real-time.



Could it be done?

I can't test it but I think
click File - Options - Advanced - Scroll down to " General" - Uncheck "Ignore other applications that use DDE"

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

OK. I unckeck it. What then next? FYI, I am using MS Excel 2010.

So I gather it did not solve your problem?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

No, it did not. How do I open a second instance physically detached from the first? I'd like to place each on separate monitors of a dual monitor system.

Seems to work for others ( not for me I'm on Linux)
http://answers.microsoft.com/en-us/m...e3a314b?auth=1

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

The link you provided clearly solves the issue of creating a second instance, but fails to address or solve the question at hand: opening the second instance in a window physically detached from the first.

Maybe the problem is with MS excel 2010, because I just happen to get access to a PC setup with 2013, and this pending issue does not seem to exist.

If this is indeed the case, I am wondering if MS provides a patch for this limitation.

I do this all the time at work.

Try...

On the View tab, in the Window group, click New Window.