Aug 09 2020 11:43 AM
how do i open multiple workbooks in one excel instance
Aug 09 2020 11:57 AM
The third-party products or Infos that this article discusses are manufactured by companies that are independent of me.
I makes no warranty, implied or otherwise, about the performance or reliability of these products or Infos.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
* Beware of scammers posting fake support numbers here.
Aug 09 2020 12:24 PM
Aug 09 2020 01:16 PM
Aug 09 2020 01:55 PM
Open all the workbooks that you want to view.
On the Window menu, click Arrange.
Aug 09 2020 11:55 PM
You're right the previous info was accidentally for Mac.
I rummaged around in Microsoft and in internet as far as possible and didn't find anything concrete in this regard.
This usually means two things.
a) It is not possible.
or
b) Nobody has been interested in whether there is such a possibility.
My last information that is a bit relevant to the topic, unfortunately I can't help anymore.
https://docs.microsoft.com/de-de/office/troubleshoot/excel/force-excel-to-open-new-instance
I hope that someone else here in the forum can help you more
Nikolino
I know I don't know anything (Socrates)
Force Excel to open by default in a new instance
Aug 10 2020 12:13 AM
Aug 10 2020 02:35 AM
I guess you mean MDI, discussion about that is here Restore MDI file handling (open all files in one window); Kill SDI (each spreadsheet opens in a sepe... . Please check latest comment from Excel team on this page.
Aug 10 2020 07:00 AM
Aug 10 2020 07:08 AM
SolutionIts only SDI on latest versions of Excel
Dec 07 2023 12:03 PM
This is an old post but someone may find it helpful.
Easy. Open the first excel workbook (or a blank one).
Select all the workbooks you want in the same instance and drag them over to the open workbook sheet.
Don't worry, it won't insert any workbooks into the initial workbook.
It will open each workbook individually with the same instance as the initial workbook.
You can then create another instance and load a group of workbooks in that instance too.
Get into the habit of just opening workbooks by dragging over to the instance you want to avoid issues.
Aug 10 2020 07:08 AM
Solution