Opening Excel File as separate process

Hi All,

I'm having trouble while working in different excel workbooks.
I use workbooks A, B and C.

I need to copy from workbook A different data into workbook B and C.

It works like this:

I delete some columns from workbook A, then paste it in workbook B.
Afterwards i need to delete different sets of columns from workbook A to paste it into workbook C.

Problem: if I do "undo" in workbook A, it does undo in workbook B.

Question: Is there some way to open workbooks A, B and C always as separate, not connected processes. So when i press undo it will undo only in the file I am currently at? If not, are there some tricks you are using to make this type of work go smooth?

If you hold Alt when opening the Excel application, it'll ask you if you want to create a new instance.

Alternatively you can create a right-click menu item to open files in a new instance of Excel.

1) Create a batch file (.bat) with the following line and place it in C
START "" "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" /e %1

2) In the Registry
Under HKEY_LOCAL_MACHINE\SOFTWARE\Classes\*\shell
Create the following key and subkey
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\*\shell\Open in new Excel instance\Command

In the value for that, add the path to the .bat file.
You should then have a new context menu to open files in a new instance of Excel.