Thủ Thuật về Which format should you use to save a file if you want it to be compatible with earlier versions of Microsoft Excel? Mới Nhất
Lê Khánh Hà Vi đang tìm kiếm từ khóa Which format should you use to save a file if you want it to be compatible with earlier versions of Microsoft Excel? được Cập Nhật vào lúc : 2022-08-30 13:22:04 . Với phương châm chia sẻ Bí quyết Hướng dẫn trong nội dung bài viết một cách Chi Tiết Mới Nhất. Nếu sau khi đọc nội dung bài viết vẫn ko hiểu thì hoàn toàn có thể lại phản hồi ở cuối bài để Ad lý giải và hướng dẫn lại nha.Many Excel users aren’t aware of the existence of Compatibility Mode and how to use it properly. It can save you a lot of time and effort, especially if you work with people that use different versions of Excel.
Nội dung chính- What is Excel’s Compatibility Mode?How to save a document in Compatibility ModeFind what Compatibility Mode your document is usingHow to leave Compatibility ModeHow to turn off Compatibility ModeHow should you save a file if you want it to be compatible with older versions of Microsoft Excel?In which format Excel file should be saved?How do I open an older version of an Excel file?What is the difference between an XLS and XLSX file?
This article goes in-depth about everything you need to know related to the Compatibility Mode view.
What is Excel’s Compatibility Mode?
Compatibility Mode is a viewing mode in Excel that helps you create documents viewable by everyone.
Excel is available in many versions since it has been around for over a decade. This inevitably means that documents made in newer versions may not be compatible with old releases. It depends on the contents of a document, which is a tricky thing to take into consideration.
For example, a feature implemented in Excel 2022 most likely won't display properly in Excel 2013. However, most users aren’t aware of this.
To giảm giá with the issue, Microsoft added Compatibility Mode to Excel. When creating a workbook in Compatibility Mode, it's going to be viewable in old Excel versions. If you're using an older version, Compatibility Mode ensures that you can view workbooks made in newer releases as well.
Without Compatibility Mode, some documents may display incorrectly or not open all. This is common when software updates change the core of an application over time. Since Excel has been around for so long, a lot has changed in its fundamentals which are addressed by Compatibility Mode.
How to save a document in Compatibility Mode
Compatibility Mode applies to documents saved in or saved for older versions of Excel. This means that you can only enter this viewing mode if you’re working with a file specifically created for this mode.
If you’re using an older Excel version, all files you create will be opened in Compatibility Mode when someone using a newer version of Excel views your workbook. On the other hand, those who work with recent releases have to prep their documents to ensure others can open it properly.
Open the document you want to save in Compatibility Mode.Go to the File menu.Click on Save As.Click on the drop-down menu that displays Excel Workbook (*.xlsx) by default. Here, simply choose an older version of Excel you wish to convert to.
Click on the Save button.
Find what Compatibility Mode your document is using
Run Excel's compatibility checker to see what mode is being used to view the document you have open. This is useful when you’re viewing a document you received from someone.
Open the document that’s already in Compatibility Mode. You can tell this by looking the document name, which should display like this: Workbook.xls [Compatibility Mode] - ExcelClick on the File menu.Go to the Info tab and click on the Check for Issues button. A drop-down menu should appear where you can select Check Compatibility.
You should be returned to your document with a new window open. Click on the Select Version to Show box and look for a checkmark. This is the Compatibility Mode the document is currently using.
How to leave Compatibility Mode
You can easily leave the Compatibility Mode view when you're done working with a document. However, don't convert a document if you or someone else needs to work with it using an older version of Excel. In this case, keeping the workbook in Compatibility Mode will ensure that the older format is preserved.
Open the document you want to convert out of Compatibility Mode.Click on the File menu.Go to the Info tab and click on the Convert button.Excel will issue a warning that your document might appear different after the conversion. If you agree to this, the Compatibility Mode will be removed from the document and you might notice some things displaying differently than before. If needed, make edits to correct these changes.
To finalize the conversion, save the document as a modern Excel document. Doing so ensures that it no longer opens in Compatibility Mode.
How to turn off Compatibility Mode
Some users are faced with an issue that all new documents are opening in Compatibility Mode. Don’t worry, this can be fixed with ease. It’s most likely caused by your default setting being an older version of Excel, which causes the software to only use Compatibility Mode.
Open Excel and either make a new document or open an existing one.Click on the File menu.Select Options from the left-side panel. This will open up a new window.Navigate to the Save tab using the left-side menu.Open the drop-down menu next to Save files in this format. Make sure to select Excel Workbook (*.xlsx) and hit OK.
Your documents should open normally now.
We hope that this article was able to help you learn what the Compatibility Mode is in Excel. Feel không lấy phí to return to our page any time you need further guidance regarding Microsoft’s spreadsheet app.
If you’re looking to read more articles related to modern technology, consider subscribing to our newsletter. We regularly publish tutorials, news articles, and guides to help you in your day-to-day tech life.
How should you save a file if you want it to be compatible with older versions of Microsoft Excel?
Follow these steps:. Click File > Export > Change File Type.. Under Workbook File Types, double-click Excel 97-2003 Workbook (*. ... . In the Save As popup window, choose a thư mục location for the workbook.. In the File name box, type a new file name (or use the one that's already there).. Click Save..In which format Excel file should be saved?
File formats that are supported in Excel.How do I open an older version of an Excel file?
Open the file you want to view. Go to File > Info > Version History. Select a version to open it. If you want to restore a previous version you've opened, select Restore.What is the difference between an XLS and XLSX file?
The File Format Difference Data is arranged in an XLS file as binary streams in the form of a compound file as described in [MS-XLS]. In contrast, an XLSX file is based on Office Open XML format that stores data in compressed XML files in ZIP format. Tải thêm tài liệu liên quan đến nội dung bài viết Which format should you use to save a file if you want it to be compatible with earlier versions of Microsoft Excel?