<div>
Hi,<br />
<br />
This is the default behavior for all versions of Excel already.<br />
<br />
If your's if opening in a new instance, then something has been changed.<br />
<br />
Alan.
</div>


<div>
We have 300 versions of Office 365 that exhibit this same behavior with no changes to the default settings.
</div>


<div>
That's very odd. &nbsp;I guess it might be a Group Policy that is being applied, even one from an older version that is having an unexpected effect.<br />
<br />
Please can you try this:<br />
<br />
1) Open two workbooks in Excel<br />
<br />
2) In Excel open the VB Editor (Alt-F11)<br />
<br />
3) In the 'Immediate' pane, please enter this line of code, and press Enter:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42350183-1"><span>?Application.Workbooks.Count</span>
</code></pre>
<br />
4) It will return a number, please post back that number.<br />
<br />
<br />
Thanks,<br />
<br />
Alan.
</div>


<div>
Okay. &nbsp;Please can you re-do that test, but with this instead:<br />
<br />
1) &nbsp;Open any workbook - it doesn't matter what workbook, but ideally with a unique name.<br />
<br />
2) &nbsp;Open a second workbook - again with another (different) unique name.<br />
<br />
3) &nbsp;In Excel open the VB Editor (Alt-F11)<br />
<br />
4) &nbsp;In the 'Immediate' pane, please enter these lines of code, and press Enter after each one - they will each return a string:<br />
<br />
?Application.Workbooks(1).<wbr />Name<br />
?Application.Workbooks(2).<wbr />Name<br />
<br />
<br />
Do the two names that it returns match the names of the two workbooks that you opened in (1)?<br />
<br />
<br />
Thanks,<br />
<br />
Alan.
</div>


<div>
Each one resulted in returning the name of the first workbook and the second workbook I opened.<br />
<br />
?Application.Workbooks(1).<wbr />Name<br />
Master1.xlsx<br />
<br />
?Application.Workbooks(2).<wbr />Name<br />
Master2.xlsx
</div>


<div>
Okay. &nbsp;That means that both workbooks are open in a single instance of Excel (rather than two separate instances).<br />
<br />
I am wondering if, rather than two instances of Excel, you mean that you want to turn off showing all the workbooks open in Excel separately in the taskbar?<br />
<br />
Please can you open two workbooks, then in Excel go to:<br />
<br />
File - Options<br />
Advanced<br />
Scroll down to the 'Display' section<br />
Show all windows in the taskbar = TRUE<br />
<br />
Change that to FALSE<br />
<br />
Does that make it look like it did before?<br />
<br />
<br />
Alan.
</div>


<div>
I can not find that option, this is what I see.<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/10_w44/1202349/1.JPG" target="_blank" title="1.JPG (31 KB)"><img alt="1.JPG" class="file-block lazyload" style="max-width: 636px;" data-src="https://filedb.experts-exchange.com/incoming/2017/10_w44/1202349/1.JPG" /></a><br />
I should probably rephrase my question. In Excel 2007 you could go to file open and open one file then another and they would both show up in the same program (under one pane of glass). Whereas now under Excel 2016 you open one file and then another it opens under two panes of glass. Sorry for the confusion on my side.
</div>


1.JPG

<div>
Are you running Win10?<br />
<br />
If so, please try this:<br />
<br />
1) Right click on the taskbar, and choose 'Taskbar Settings'<br />
<br />
2) Halfway down there is a setting called 'Combine taskbar buttons'<br />
<br />
3) What is yours set to? &nbsp;If not already, try changing it to 'Always, hide labels'<br />
<br />
<br />
Does that make any difference?<br />
<br />
<br />
If you have multiple displays, you might need to scroll down further in the 'Taskbar Settings' screen, and change:<br />
<br />
'Show taskbar buttons on' setting to be 'Taskbar where window is open'<br />
<br />
and<br />
<br />
'Combine Buttons on other taskbars' setting to also be 'Always, hide labels'.<br />
<br />
Alan.
</div>


<div>
They were both set at &nbsp;(Always, hide labels)<br />
<br />
-Windows 10 Pro 64bit
</div>


ShowAllWindowsInTheTaskBar.bmp

<div>
They must have removed that option in Office 365. Thanks for your help!
</div>


<div>
No problem - I would be happier if we had a solution!
</div>


<div>
<div class="content wysiwyg-content">
Has anyone found a way to have by default all Excel files to open into one instance like Office 2007 allowed? We are using Excel 2016 and we are only able to have Excel files being opened to create a &nbsp;new instance for each one. In other words each .xlsx we open we want it to default to open under the same window. Thanks
</div>
</div>


Has anyone found a way to have by default all Excel files to open into one instance like Office 2007 allowed? We are using Excel 2016 and we are only able to have Excel files being opened to create a  new instance for each one. In other words each .xlsx we open we want it to default to open under the same window. Thanks

Default all Excel files being opened to one instance (like Office 2007 allowed)

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.