By Martin Jansen, Owner of Jansen-PCINFO
Recently, one of my customers attempted to install Microsoft 365 on his new Dell Laptop. The installation went well until he discovered that he would have to pay a subscription fee of $100 per year for the family plan ($70 for a personal plan). The reason he installed it in the first place was that someone sent him a spreadsheet that he wanted to open and enter some data.
Coming from the business world, my customer thought that Microsoft Excel was the only answer for opening the file. On the contrary, there are many free office suites that can open .xlsx files. LibreOffice is one of my favorites, but WPS Office, Apache OpenOffice, FreeOffice and Google Sheets can open the files. Microsoft has its own limited online versions of Word, Excel and Powerpoint, but you will be limited to 5 GB of storage compared to Google’s 15 GB storage and you will be prompted to purchase the full version of Microsoft 365 with 1 TB of space.
File Format Mess
Windows, like many operating systems, uses file extensions (like .docx for Microsoft Word) to manage which applications open when double clicking on a file. My customer’s attempt to install Microsoft 365 really messed up the associations. When he double clicked on the file sent to him, it opened Excel, but there was a warning at the top that Microsoft 365 was not activated and he could not enter any data in the cells. And, of course, activating 365 would cost him $100. Full circle.
Installing 365 also took over the .ods format which stands for OpenDocument Spreadsheet. Excel can open these files, but will not write the files without losing some formatting. When I opened the previously installed LibreOffice the app warned that the .ods extension was in use by another application – Excel. In fact, Microsoft 365 would like to take a lot of extensions on a computer.
Changing Extension Associations
So, we know that Microsoft is an extension hog: We can change the extension associations by following these steps:
- Right (not left) click on the Start Button
- Select Settings
- Select Apps
- On the left side select Default apps
- Scroll down and select Set defaults by app
Then fix each file association for instance in this chart I associate the extension with the three most commonly used LibreOffice Applications:
|Document Related File Formats
|Word 97-2003 Document
|Word Macro-Enabled Document
|Strict Open XML Document
|Word 97-2003 Template
|Word Macro-Enabled Template
|LibreOffice Writer default format
|All modern wordprocessing applications can save or export PDF files.
|Rich Text Format
|Works 6-9 Document
|Spreadsheet Related File Formats
|CSV (Comma delimited)
|LibreOffice Calc default format
|Modern spreadsheet software can save as PDF, but must watch formatting which can exceed margins or make the text tiny and unreadable
|Formatted Text (Space delimited)
|Text (Tab delimited)
|Excel 97-Excel 2003 Workbook
|Microsoft Excel 5.0/95 Workbook
|Excel Binary Workbook
|Excel Macro-Enabled Workbook
|Excel 97 – Excel 2003 Template
|Excel Macro-Enabled Template
|Excel 4.0 Workbook
|Presentation Related File Formats
|LibreOffice Impress default format
|Modern presentation software can save as a PDF
|PowerPoint 97-2003 Template
|PowerPoint Macro-Enabled Template
|PowerPoint 97-2003 Add-In
|PowerPoint 97-2003 show
|PowerPoint Macro-Enabled Show
|PowerPoint 97-2003 Presentation
|PowerPoint Macro-Enabled Presentation
Perhaps an easier way is to reinstall the application to fix file associations:
- Type WIN+R and enter appwiz.cpl
- Uninstall Office 365 and leave the extensions abandoned
- Uninstall LibreOffice
- Reinstall LibreOffice to recapture the associated extensions
On the way to changing extensions, the steps take you through the default apps. Microsoft would very much like you to use Edge as your default browser. Edge is based on Google Chrome, but many would just like to have Chrome as their default browser.
After you install Google Chrome, it does not become your default browser. You must change the default app in settings. When you change the default browser from Edge to Chrome a warning box appears reading, basically, that Edge is better – please don’t change. Microsoft’s claim is not true, but, when did facts get in the way of big business? Make the change anyway and enjoy Chrome just like you are used to doing.
Even then, you can’t uninstall Edge conventionally. It pops up whenever you click on Microsoft sponsored content. Here is a guide from Tom’s Hardware if you really want to uninstall the browser. It’s simply not worth the hassle if you ask me.
In Windows use Default Apps to fix the extensions associated with the applications. Search for Default Apps in both Windows 10 and 11. Scroll to the button to select Set defaults by app and find the extension that is opening the wrong app. On the way, if you want to install another browser, this is where you can change from Edge.