Windows 10: How to make Excel 2016 the default app to open xls and xlsx data files

Discus and support How to make Excel 2016 the default app to open xls and xlsx data files in Microsoft Office and 365 to solve the problem; I know how I'm supposed to do it, SETTINGS==>DEFAULT APPS==>CHOOSE THE DEFAULT APP BY FILE TYPE, but Excel 2016 is not an option. Instead, it tries to... Discussion in 'Microsoft Office and 365' started by socklosk, Sep 9, 2016.

  1. socklosk Win User

    How to make Excel 2016 the default app to open xls and xlsx data files


    I know how I'm supposed to do it, SETTINGS==>DEFAULT APPS==>CHOOSE THE DEFAULT APP BY FILE TYPE, but Excel 2016 is not an option. Instead, it tries to send me to the App Store. I think I have tried everything except reinstalling Office.

    :)
     
    socklosk, Sep 9, 2016
    #1

  2. Excel not recognized as an app in Windows 10.

    Hi

    I had this problem as well when upgrading Office 365 to 2016 in Windows 10. It relates to Excel 2016 only recognising newer ".xlsx" files as worksheets and not the older excel files (".xls"). Opening ".xls" files from within Excel 2016 worked just fine,
    but not being able to open them by clicking the file in a folder is a nuisance

    I solved it by doing the following

    Go to "Settings" - "System" - "Default apps"

    Scroll down, select "Set defaults by app"

    Select "Excel 2016"

    Select "Choose defaults for this program"

    A list of file types will come up including ".xls" which in my case was blank.

    Tick the ".xls" box and save

    When you next click on a ".xls" file you will be given the option for Excel 2016. Once this is selected once, it seems to work for other ".xls" files. However, a pop-up stating that "Excel is not the default for editing spreadsheets" will come up which
    I just close.

    Hopefully a later upgrade will fix it, at least this work around means you don't have to open ".xls" files from within the Excel app.
     
    MilesCudmore, Sep 9, 2016
    #2
  3. tsuyosumo Win User
    Excel file type disappeared

    Thank you for your prompt reply.

    The lost of .xls has no option for choosing Excel 2016, however other most .xl files could choose Excel 2016.

    And when my older version excel file opened with Adobe, it cannot display correctly.

    Any other method can help this issue fix?

    Thank you.
     
    tsuyosumo, Sep 9, 2016
    #3
  4. cereberus Win User

    How to make Excel 2016 the default app to open xls and xlsx data files

    Use Control panel, default programs, associate a file type - you have more options to select version.

    If your 2016 is the desktop version, you have to bury into menus by clicking more apps and scrolling until you find "look for another app on this pc", and then navigate to the 2016 excel executable.
     
    cereberus, Sep 9, 2016
    #4
  5. I do not get the option to look for another app on the pc, I get the option to look for an app in the app store.

    Why is Microsoft trying to be Apple ?
     
    john kingston, Jul 19, 2017
    #5
  6. Berton Win User
    Have you tried going into Control Panel, Default Programs and making changes there to set the file type/s to open as desired?
     
    Berton, Jul 19, 2017
    #6
  7. For some reason it wont update the setting for Excel 2016 to open .xls files

    Default Apps
    Set default by app
    Excel 2016
    Choose defaults for this program
    tick .xls Microsoft Excel 97-2003
    Current default - unknown application
    save

    Does not update the current default from unknown application

    (unfortunately I dont know how to screen dump the screen I am looking at )

    John
     
    john kingston, Jul 20, 2017
    #7
  8. How to make Excel 2016 the default app to open xls and xlsx data files

    I am having the exact same issue as John posted above.
    I've tried the above option as well as changing the protected view settings - nothing works. This is extremely annoying and I agree with an earlier poster who said "Why is Microsoft trying to be Apple" If you have a product that works please keep it operating in the same fundamental manner. I don't want to go to the $^%# app store. Any assistance will be well received. Here is a screen shot:


    How to make Excel 2016 the default app to open xls and xlsx data files [​IMG]
     
    dshields13, Aug 10, 2017
    #8
  9. Callender Win User
    You are supposed to double click on the entry for .xls in control Panel > Set Associations and in the window that opens choose "More Apps" then in the file explorer window that opens up browse to the Excel executable and select it.


    How to make Excel 2016 the default app to open xls and xlsx data files [​IMG]


    How to make Excel 2016 the default app to open xls and xlsx data files [​IMG]


    See: Cant find Office applications in Windows 10, Windows 8, or Windows 7? - Office Support

    So launch Excel and leave it running. Start Task Manager [Ctrl+Shift+Esc]

    In task manager processes tab scroll to excel.exe and right click on it. Choose "open file location" from the list and in the window that opens locate excel.exe and note the folder path. Use that path to browse to the executable in the step above that mentions browsing to the executable.
     
    Callender, Aug 11, 2017
    #9
  10. Thanks for the info but unfortunately when I double click NOTHING happens *Sad
     
    dshields13, Aug 12, 2017
    #10
  11. I really appreciate your help, but I keep getting the pop-up that sends me to the app store *Sad
     
    dshields13, Aug 12, 2017
    #11
  12. HIP HIP HOORAY!!!!!!!!!!! Finally overcame this PITA issue, no thanks to MS. Thinking about moving to Mars and never coming back after this ordeal.
     
    dshields13, Aug 12, 2017
    #12
  13. Callender Win User

    How to make Excel 2016 the default app to open xls and xlsx data files

    Attachment 148604
    Sorry about that. I forgot about app store lookup for files that cannot be opened. That's because on my machine I set it not to look up apps in the store so instead it offers to allow the user to browse for a program that's installed on the PC (or needs to be installed)Attachment 148604
     
    Callender, Aug 12, 2017
    #13
  14. mrgeek Win User

    Have you tried this brute force setting in Control Panel where you set Excel as the default program for EVERYTHING it is capable of opening ?

    How to make Excel 2016 the default app to open xls and xlsx data files [​IMG]
     
    mrgeek, Aug 12, 2017
    #14
  15. lurahlee Win User
    TO: whoever it was that made the comment about opening Excel then opening the Task Manager to be able to see where Excel 2016 was residing...................thank you! That was such an elegant solution which allowed me to fix the Excel 2016 not wanting to acknowledge the .xls extension problem. I was pulling my hair out, like the other people on this thread trying to associate an extension to a program that just wasn't showing up in the lists like it should. Once I knew where Excel was, then I could find it through the 'browse your computer', just like you said.

    Anyway, I just joined the forum to tell you thanks....you helped me that much. I'm an accountant who just converted to Win 10 and Excel 2016 so this was a REALLY BIG DEAL.
     
    lurahlee, Sep 16, 2017
    #15
Thema:

How to make Excel 2016 the default app to open xls and xlsx data files

Loading...
  1. How to make Excel 2016 the default app to open xls and xlsx data files - Similar Threads - Excel 2016 default

  2. How to reset default app for all 'open file with'

    in Windows 10 Network and Sharing
    How to reset default app for all 'open file with': [ATTACH] How can i reset the option 'open file with' to dafault app. https://answers.microsoft.com/en-us/windows/forum/all/how-to-reset-default-app-for-all-open-file-with/d7e54c63-68a7-4f22-95e6-ded8b89d1d67"
  3. can not open an xlsx file on an email attatchment

    in Windows 10 Customization
    can not open an xlsx file on an email attatchment: I have been sent in my email, an xlsx attatchment and it wont open, how can i open this attatchment, i am on Windows 10. https://answers.microsoft.com/en-us/windows/forum/all/can-not-open-an-xlsx-file-on-an-email-attatchment/fffe2778-8bf2-46c5-bc6a-ab4e65f21113
  4. How to select 'browser apps' as default apps for opening documents/files?

    in Windows 10 Customization
    How to select 'browser apps' as default apps for opening documents/files?: As most people know, browsers like Google Chrome and probably the new MS Edge can 'create' applications for some websites like Gmail, Outlook, OneNote, etc. I'm using a lot of these Apps, some of them are from Google, like Documents and Sheets. My question is, how I...
  5. Excel 2016

    in Windows 10 Customization
    Excel 2016: How do I customize the default date format in Excel 2016 to this -- Mmm dd / yyyy https://answers.microsoft.com/en-us/windows/forum/all/excel-2016/1e4038d6-9a54-44e0-9556-925b91cef13a
  6. recover xls data

    in Windows 10 Network and Sharing
    recover xls data: is there any way to extract cell content from a corrupted excel file, formulas can always be reentered but if there is a way of getting text and results in cells that would be great...
  7. Make notepad the default app for .m3u files

    in Windows 10 Network and Sharing
    Make notepad the default app for .m3u files: How do I set notepad to be the default app to open m3u files? All of the routes I've tried so far don't work. i.e. via settings, control panel and the target file's properties panel....
  8. Default apps for opening files

    in Windows 10 Software and Apps
    Default apps for opening files: How do you change the programs/apps which appear on the drop-down lists next to each file extension type in the "Choose default apps by file type" menu? I'm trying to associate the Windows Photos app with the .webp extension which Google is now saving many of my pictures...
  9. how to backup only .xls & xlsx files in Win10 on offline computer

    in Windows 10 Backup and Restore
    how to backup only .xls & xlsx files in Win10 on offline computer: how to backup only .xls & xlsx files in Win10 Pro Insider on offline computer ( no internet connection but office pro 2016 installed , most times no login to MS account on my uncles PC ) so that I can backup only excel files with extension .xls & .xlsx over portable HDD...
  10. downloading excel file changes file extension to .xlsx

    in Microsoft Office and 365
    downloading excel file changes file extension to .xlsx: I have tried to download an Excel (.xls extension) from a web site I use. On download I get a file with a .xlsx extension which will not open in Windows Office 2010. I successfully downloaded the file using Chromodo so I assume there is something corrupting the download via...