Summary: In this guide, you will learn why Excel 2016 won’t open XLS files in Windows. Also, different methods as well as workarounds to fix the issue and to open the older XLS format spreadsheets in Excel 2016 or later versions.
- Can I Download Xls Files On A Mac Download
- Can I Download Xls Files On A Macbook Pro
- Can I Download Xls Files On A Mac Os
- Can I Download Xls Files On A Mac File
XLS is a Microsoft Excel spreadsheet file format, used by Excel 2003 and earlier versions. From Excel 2007 and later, a new XLSX format was introduced by Microsoft that is much secure and better at storing data.
Since XLS is an older Excel file extension, you may experience errors while opening the XLS files in Excel 2016, such as, “Excel cannot open the file .xls because the file format or file extension is not valid.”
Excel 2016 won’t open XLS files due to compatibility issues, which is a common problem. It usually occurs after upgrading the MS Office or Windows OS. However, this problem may also occur even after a minor MS Office or Windows update.
NOTE: XLS file may also won’t open if it’s corrupt or damaged. If the XLS/XLSX file was opening earlier but does not open anymore, it indicates corruption. In such a case, you can use the Excel Repair software from Stellar®. The software is free to download and lets you scan the damaged XLS file. If it’s corrupt, the software repairs it and previews the data stored in the XLS file. You can then save this XLS file in a new XLS file and open it in MS Excel 2016 without any issue. Watch this video to know more,
Fortunately, there are many fixes and troubleshooting methods that you can follow to fix this issue and open the XLS files in Excel 2016.
Hello Galina, Yes its possible to convert your.doc files to.xls files on your current Mac os you are right it's sound fantastic for those who didn’t try this one on there Mac its very simple just open Google of the largest search engine in search write.doc to.xls converter in search you can see many site some of them allows you to convert directly no need to install if you want to use it. Using the Best XLS to PDF Converter. PDFelement Pro for Windows - The Best Way to Transfer.
Methods to Open XLS Files in MS Excel 2016
Follow these methods in the given order of sequence to resolve ‘Excel 2016 won’t open XLS files’ issue and open the XLS files in Excel 2016.
Method 1: Open XLS File from MS Excel 2016
Instead of opening XLS file by double-click, open the MS Excel 2016 first and then,
- Go to File>Open>Browse
- Navigate to the XLS file that won’t open in Excel 2016
- Select it and click ‘Open’. This should open the XLS file without any issue
If it doesn’t, follow the next method.
Method 2: Manually Open the XLS File by using the EXCEL.EXE Program File
This method has worked for many users when their Excel 2016 can’t open the XLS files in Windows 10. Steps are as follows,
- Right-click on the file with the .xls extension that won’t open in Excel 2016
- Select Open with from the options and then click on Choose another app. This opens a dialogue box
- Click ‘More Apps’ from “How do you want to open this file?” options
- Then click ‘Look for another app on this PC’. This opens a File Explorer window
- Navigate to EXCEL.EXE location which is usually located at,
C: Program Files (x86) > Microsoft Office > root > Office 16 > EXCEL.EXE
- Click on EXCEL.EXE file and click ‘Open’. Your .xls file should open right up
From now onwards, all .XLS files will get associated with Excel 2016, including the new .XLS files that you move, download or copy to your system. In short, Excel 2016 will become the default app to open .XLS files in your system.
Method 3: Edit Microsoft Trust Center Settings
Trust Center is an option in MS Excel that contains the privacy and security settings for MS Office programs. It helps keep system secure. However, by changing certain settings in Trust Center, you may be able to open the XLS file in Excel 2016. To do so, follow the given steps:
Can I Download Xls Files On A Mac Download
- Open Microsoft Excel 2016, go to File>Options
- Click on Trust Center and then click on Trust Center Settings
- Select Protected view on the left and un-checkall the options in the Protected View options
- Click OK and restart MS Excel 2016.
Then try to open the Excel workbook (XLS file).
Method 4: Convert XLS files to XLSX
In MS Excel, compatibility mode lets you open and convert the XLS Office files, so they become usable in later versions. However, there are two issues with Compatibility Mode,
- After conversion, it changes the layout of the spreadsheet
- You can’t go back – once the XLS file is opened and converted to the new XLSX format, you can’t reverse it or go back
Can I Download Xls Files On A Macbook Pro
Thus, the best way to do it safely is to back up the XLS file and then follow the steps below,
- Open the XLS file and go to File >Info
- Click ‘Convert’ button in Compatibility Mode section
- Click Convert and then click OK, if prompted
- This will convert the old XLS spreadsheet to new XLSX format which is supported by Excel 2016
- Restart Excel and open the converted XLSX file
Method 5: Repair and Save Excel Workbooks with Stellar Repair for Excel
If the methods mentioned above did not work and Excel 2016 still won’t open XLS file, then the file is corrupt and requires immediate recovery. You can use Stellar Repair for Excel to fix the corruption and save the spreadsheet as a new XLS file. The software preserves spreadsheet properties such as cell formatting, freeze panes, split, gridlines, formula bar, etc. while fixing the corruption and saving the new Excel file.
You can fix all kinds of Excel file corruption with this software and get back your data. It supports all MS Excel versions starting from Excel 2000 to 2019. Moreover, you can choose to repair single as well as multiple XLS/XLSX files at once.
After repair, you can open the XLS file in Excel 2016 and save it in new XLSX format.
Conclusion
If you cannot open XLS Excel file in MS Excel 2016, follow the methods discussed in this post. Sometimes, a simple workaround resolves the issue. However, if you can’t open the XLS in the Excel 2016, you should use an Excel recovery tool such as Stellar Repair for Excel.
When nothing works, then the XLS file is probably corrupt which can be repaired by using this Excel repair software from Stellar®. All you need to do is choose the XLS file, click on Repair and then save the spreadsheet to a new XLS file that you can open in Excel 2016/2013 and even in 2019. You can try it, the software is free to download.
Safari User Guide
Can I Download Xls Files On A Mac Os
Safari can download most types of files, but if you have trouble with a file, try these suggestions.
If Safari is still downloading the file, wait for it to finish. You can’t open a file while it’s being downloaded.
If the download is paused, resume it. Show the downloads list by clicking the Show Downloads button , then click the Resume button for the paused download.
If you see a message that the app can’t be opened because it’s from an unidentified developer or wasn’t downloaded from the Mac App Store, you can open the app by overriding the settings in Security & Privacy preferences.
Sometimes a download is incomplete because the file was damaged. Try downloading it again.
Make sure you have the app needed to open the file. If you do, the file may have been corrupted during the download. Delete it, then try downloading it again.
The downloaded file may be a compressed archive or disk image that contains the file you want. If the file is from a trusted site, double-click it to decompress it.