Excel 2010 Opening Files in Single Instance after a Recent Update


  1. Posts : 384
    Window 10
       #1

    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 Computer


  2. Posts : 31,471
    10 Home x64 (22H2) (10 Pro on 2nd pc)
       #2

    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 Computers


  3. Posts : 384
    Window 10
    Thread Starter
       #3

    Bree said:
    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 Computer


 

  Related Discussions
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 00:48.
Find Us




Windows 10 Forums