I prefer working with different Excel sheets in separate windows, however, I discovered a flaw in excel on one of my machines running office. If you work on two different Excel sheets (side by side) you’ll find you can only work on one excel sheet at a time, (depending on your version of office) this is annoying.
I have found a walk around for this problem which involves changing registry entries’ on your computer
Microsoft Excel walk around – as a note; underlines are used to highlight a specific section, don’t include any underlines in any of your modifications. I have included a disclaimer below:
(Disclaimer: I don’t take any responsibility for any damage or loss of data as a result of changing or making any modifications to your computers registry).
I have tried and tested this update on my own computer and have not experienced any issues.
Open up Windows registry editor
- Hold the Windows key down (next to your CTRL key) and press R
- Type in: regedit in your Run box and click ok.
This opens your registry editor, once this has loaded up select the following:
- HKEY_CLASSES_ROOT (select the arrow next to the folder to expand this section)
- Scroll down and locate the folder: Excel.Sheet.12, expand this section.
- Select the shell folder
- Select the Open folder
- Next you will see a folder called command, select this folder.
- To the right you will see the name (Default) right click this and select Modify.
- You will have this /e at the end of your Value data, add the following: “%1” to the end of this section and click ok.
- Under (Default) you will see command, select this, right click this section and rename this to command2 (without the underline).
- Look at the yellow folders to your left, below the yellow folder command there is a folder called: ddeexec, rename this to ddeexec2.
- Go to your folders in the pain to your left
- Scroll down and locate the folder: Excel.Sheet.12, under this folder go to Excel.Sheet.8 and repeat the process you done in Phase one to this section.
Once you have completed this task, close down your registry editor and open your excel documents, you should be able to open two separate excel sheets.
If you have found this useful leave a comment below.