Windows 10: Excel 2010 Opening Files in Single Instance after a Recent Update

Discus and support Excel 2010 Opening Files in Single Instance after a Recent Update in Microsoft Office and 365 to solve the problem; 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... Discussion in 'Microsoft Office and 365' started by PJLLB, May 5, 2017.

  1. PJLLB Win User

    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?

    :)
     
    PJLLB, May 5, 2017
    #1
  2. d0gknees Win User

    In Task View I cannot switch between two Excel spreadsheets operating simultaneously

    Billion - You use Ctrl-tab to switch between multiple files open in one instance of Excel.

    Excel opens the files in a single instance of the application, so you only see the one in Taskview. Word opens the files in separate instances of Word so you see several in Taskview.
     
    d0gknees, May 5, 2017
    #2
  3. B. Parker Win User
    WP Excel won't open Excel 2010 Spreadsheets

    I use Office 2010 (32 bit) on my Win7 Pro computer.

    I have been using my Windows Phone 7.5 to open/edit Excel 2010 files stored on Skydrive for some time.

    Suddenly, WP will not open the same files which it could open just awhile ago.

    I have used Excel 2010 to edit these spreadsheets since the last time I opened them with WPExcel and saved them in the same format as before.

    WPExcel states:

    "Can't Open. Excel doen't recognize the file format "<filename"".

    Yet these files open without issue with Excel 2010.

    Any suggestions?



    Update - WPExcel will open cloud Excel files that have not been recently opened by Excel 2010. Those files operate properly. However, once I open the same files with Excel 2010 and save them - WPExcel can not open them. Problem with Excel 2010?
     
    B. Parker, May 5, 2017
    #3
  4. Bree New Member

    Excel 2010 Opening Files in Single Instance after a Recent Update

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

    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.
     
    Bree, May 6, 2017
    #4
  5. PJLLB Win User
    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.
     
    PJLLB, Apr 5, 2018
    #5
Thema:

Excel 2010 Opening Files in Single Instance after a Recent Update

Loading...
  1. Excel 2010 Opening Files in Single Instance after a Recent Update - Similar Threads - Excel 2010 Opening

  2. Deleted apps for word 2010, excel 2010, powerpoint 2010

    in Windows 10 Software and Apps
    Deleted apps for word 2010, excel 2010, powerpoint 2010: My PC had to be reset today. After I noticed my Microsoft Word 2010, Excel 2010 & Powerpoint 2010 were gone. I do have my original receipt but not the original packaging. How can I reinstall these apps....
  3. Excel cannot open files

    in Windows 10 Network and Sharing
    Excel cannot open files: I found in the last two to three days that XLSX files are not opening and i am getting the below mentioned message. Can you please help out Excel cannot open the file 'Salary working file Feb'19.xlsx' because the file format or file extension is not valid. Verify that the...
  4. Excel Starter 2010

    in Windows 10 Network and Sharing
    Excel Starter 2010: After each automatic download from microsoft my Aspire Lap top locks up with a blank black screen after I log in with my pass code. I generally have to shut down and restart my computer in safe mode. Apparently the Task Manager does not start in the initial startup. The last...
  5. I cannot open recent files (Excel, Word, Adobe reader)

    in Windows 10 Network and Sharing
    I cannot open recent files (Excel, Word, Adobe reader): Previously when I wanted to open a recent file, I just right clicked the app in the start menu and selected the file. I currently see the recent files but cannot open them. I am not sure when it started but probably after update....
  6. Recent files not opening

    in Windows 10 Network and Sharing
    Recent files not opening: Hello, I recently (maybe after an updated, but no sure) noticed my recent files are not opening. For example I have excel, adobe reader and word on my start menu. Usually when I want to open a document I'm working on I right click the app and choose the document. But when I...
  7. Follow Hyperlink in Excel 2010

    in AntiVirus, Firewalls and System Security
    Follow Hyperlink in Excel 2010: I am using W10 fully updated and Office 2010 64 bit and Chrome is my default browser (It makes no difference if I default to IE, Edge or Firefox) I have some code in my worksheet as follows: Dim filename Sub test() filename = ThisWorkbook.Path & "\Settings\Bing Maps.html"...
  8. after last update no excel files will open

    in Windows 10 Installation and Upgrade
    after last update no excel files will open: get the following error - [ATTACH] https://answers.microsoft.com/en-us/windows/forum/windows_10-update/after-last-update-no-excel-files-will-open/5bbdb225-def5-4c59-95c9-f92bb5d66e6a
  9. Windows Mail app does not open Excel 2010 attachments

    in Browsers and Email
    Windows Mail app does not open Excel 2010 attachments: If I try to open an Excel file from the Windows Mail app, Excel 2010 starts, as expected, but the file is not opened. No error message, just a new empty spreadsheet is opened. I can save the spreadsheet and open the file, which is a little awkward. Am I tainting Microsoft by...
  10. Microsoft Word and Excel 2010 files disappeared

    in Windows 10 Installation and Upgrade
    Microsoft Word and Excel 2010 files disappeared: I unintentionally uninstalled Windows 10 yesterday by restoring Windows 7. I immediately reinstalled Windows 10 but now my Microsoft Word and Excel 2010 shortcuts don't allow me access and say they are not installed and I can't find where I can get them back....