1.    06 May 2017 #1
    Join Date : Sep 2014
    Posts : 335
    Window 10

    Excel 2010 Opening Files in Single Instance after a Recent Update


    After a recent update to Excel 2010 (that came after upgrading Windows 10 Creators Edition) when clicking on more than one Excel file they all open in the same window (instance) of Excel. Before this update the files would open in separate instances. By opening in a single instance of Excel it is then necessary to either arrange the workbooks (tile, etc.) or switch between them. But this is not what I want to do -- I want to be able to open both files in separate Excel windows so that I can easily see them both in large screen windows on separate monitors like I did before this update.

    I found a suggestion online to check the Ignore other applications that use Dynamic Data Exchange (DDE) advanced option in Excel. But this results in Excel opening itself with no open workbook when clicking on a file.

    Word 2010 does not behave in this manner. If I click to open one Word file and then another, each is opened in a separate window (instance) of Word, which is what I want to do with Excel.

    Any thoughts?
      My ComputerSystem Spec
  2.    06 May 2017 #2
    Join Date : Aug 2016
    S/E England
    Posts : 4,503
    10 Home x64 (1709) (10 Pro on 2nd pc)

    This Excel 2010 behaviour seems to be by design with little or no way to change it.

    One workaround is to first open Excel itself rather than by clicking on a file. You can open as many Excel windows as you want that way. Then in each instance of Excel use 'File.. open' to open one of your spreadsheets, or click and drag each of your files and drop each one into a different Excel window.
      My ComputersSystem Spec
  3.    07 May 2017 #3
    Join Date : Sep 2014
    Posts : 335
    Window 10
    Thread Starter

    Quote Originally Posted by Bree View Post
    This Excel 2010 behaviour seems to be by design with little or no way to change it.

    One workaround is to first open Excel itself rather than by clicking on a file. You can open as many Excel windows as you want that way. Then in each instance of Excel use 'File.. open' to open one of your spreadsheets, or click and drag each of your files and drop each one into a different Excel window.
    Possible, except why did it start behaving this way only after the updates installed since upgrading to the Windows 10 Creators Edition?

    Microsoft strikes again.
      My ComputerSystem Spec

 


Similar Threads
Thread Forum
Recent update has led to loss of network files on my desktop
After the last update of Windows 10 the network folders have disappeared from my desktop. The folders exist on my laptop and I am able to access them there, but all I have on the laptop network is a default migrated folder. Any idea where the...
General Support
Taskbar Button How to always start a new instance on single left clicK
Win10 V.1511 and V.1607. Example TaskBar Button - File Explorer If you open an instance of File Explorer, then click the task bar button again, File explorer window minimizes. If you right click, a popup opens with Pinned, Frequent, and File...
Customization
Solved I cannot email from MS Word or Excel 2010 = MAPI failure
This has happened after I upgraded to Windows 10. The help section tells me to associate Word & Excel with a mail program but doesn't tell me how to do that. I am using Windows 10 mail app. I know I can go into settings to associate files with...
Software and Apps
Solved New Problem - Outlook 2010 Links Not Opening
Sorry, I searched but did not see another thread on this topic. This just started today, maybe after a reboot. Up until today, when I clicked on a hyper link in an email, the link location would open in Firefox, my default browser. Now all of a...
Browsers and Email
Unable to save to 2010(offfice) excel after Win 10 upgrade
I get the following message after I try to save a file using excel. You don't have permission to save in this location. Contact the administrator to obtain permission. It is trying to save in C://users/Jimmy/documents/copy of weather 2007.xls. No...
Software and Apps
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 20:05.
Find Us
Twitter Facebook Google+ Ten Forums iOS App Ten Forums Android App



Windows 10 Forums