Forum Discussion
How do I have Excel treat each file separately - for search, undo, etc.
I thought I had wrapped this up by saying that the option to start independent instances of Excel by using the /X startup option is my solution. This makes each file independent with separate undo and find/replace boxes. But, I did not see that this morning when MS asked me to indicate the best solution. mathetes
djc2002us That might be because they either don't allow or discourage marking your own response to a thread you started as the best solution. That said your point about using the /X option is a good one. Here is a "step more". Either create a new shortcut or modify the shortcut you already use to launch Excel (for example the short cut used by the start menu) to include that "/X" option. (Note you may need administrator permission). To create a new shortcut either copy and existing shortcut or right click and drag the application icon to the location you want it and select 'Create shortcut'. I then recommend you give it a new name like "Excel - New Window" to distinguish it from the original shortcut.
Then to modify the shortcut:
Right click the shortcut and click 'Properties'.
Then in the field that says "Target" add the /X after the end of the existing ""
It should look something like this but your path might be different: "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" /X
Finally move, add or copy that shortcut to where ever you want to easily open Excel in a new window.