Open Multiple Workbooks in the Same program Window

Question

hi

using excel 2016

when i open new workbooks, they keep opening in their own program window.

and when i have multiple workbooks open, makes my desktop a big mess.

is it possible to open each new workbook, in the same program window?

i do not need to view all workbooks at the same time.

Answer 1

Hi

Thank you for posting your query. My name is Clarence, I'll be more than happy to assist you with your concern.

To resolve your query kindly do the steps below.

The solution involves making little changes in the registry so i recommend making back up for just in case:

strart - run - regedit:

Left column

HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/commend:

Right column {adding (space)"%1"}

Double Click on (Default) and write - "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"

Right Click on Command – choose "rename" and add something to the name - for example 2 (commend2).

Left column

HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/ddeexec:

Right Click on the folder ddeexec and choose "rename" and add something to the name - for example 2 (ddeexec2)

Left column

HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/commend:

Right column {adding (space)"%1"}

Double Click on (Default) and write - "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"

Right Click on Command – choose "rename" and add something to the name - for example 2 (commend2).

no restart needed.

Go to this link for your reference and other troubleshooting procedures https://answers.microsoft.com/en-us/msoffice/forum/all/stop-excel-files-from-opening-in-the-same-window/53f8144b-bccf-4260-a7b0-a0179d271527

Do not hesitate to message us if you need further assistance.

Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

Best Regards,
Clarence

Answer 2

Re: is it possible to open each new workbook, in the same program window?

The last Excel/Office version that did that was XL2010.
MS claimed that multiple windows simplified use on multiple displays.

Actually, it was just another method to obsolete older office versions.

I paid for XL2010, got a disc and have been happy with it.

'---
Nothing Left to Lose

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

(free excel programs)

Answer 3

hi

my issue is not the task bar

my issue is having 5 excel files open at the same time, all in seperate wondows.

if i want to minimize excel, i have to go to each window one by one and minimise

Answer 4

Hello Brianhak,

Thank you for posting your question in our community, kindly use the steps below:

Right click on taskbar, click on settings. Scroll down until you see “Combine taskbar buttons” drop down, then change "always, hide labels".

Let us know if the issue persists after that.

Best Regards,
Asher