Running the Compatibility Checker can help you identify features or information that might not be available in an earlier version, so you can resolve some of those issues before you share your workbook.
If the Compatibility Checker appears, review any compatibility issues that were found. The Find link takes you to that place in your worksheet, and the Help link takes you to information on the issue and possible solutions. In your new version of Excel, the workbook you just saved in.
Keep working in this mode when you plan to send this workbook back and forth to people who open it in the earlier version of Excel. To verify that a workbook is compatible with Excel , , or , run the Compatibility Checker manually the first time you save your workbook. Then set the Compatibility Checker to run automatically every time you save that workbook. To check for compatibility automatically from now on, check the Check compatibility when saving this workbook box.
Tip: You can also specify the versions of Excel that you want to include when you check for compatibility. All versions are checked by default, so just uncheck the versions you don't want to include. If any issues are found, the Find link takes you to that place in your worksheet, and the Help link takes you to information on the issue and possible solutions.
Note: You can also use the VLOOKUP function in Excel to address this issue, but the process is somewhat complicated, and becomes more complicated as the number of data sources to combine increases. Note: The file formats that are available vary, depending on what type of sheet is active a worksheet, chart sheet, or other type of sheet. Tip: For more information on how to save a workbook in PDF. You can save any file format that you can open in Excel and later in the current Excel Workbook file format.
By doing this, you can use new features that are not supported by other file formats. Note: When you save a workbook that was created in an earlier version of Excel as an Excel and later workbook, some formats and features may not be retained. For information on unsupported Excel features, see Use Excel with earlier versions of Excel. To save the file to a different location, specify the drive and location in the file path and folder boxes. If you are saving a workbook that was created in an earlier version of Excel, the workbook contains macros that you want to retain, and you want to save the workbook as a template, click Excel Macro-Enabled Template.
In the Save category, under Save workbooks , in the Save files in this format box, click the file format that you want to use by default. The Save As command is not available as a button on the ribbon. You can, however, add the command to the Quick Access Toolbar. In the Choose commands from box, make sure that Popular Commands is selected. You can save a Microsoft Office Excel workbook in a different file format. You can save a workbook in an earlier version file format, in text file format, and in other file formats, such as PDF or XPS.
You can also save any file format that you can open in Office Excel as an Excel workbook. By default, Excel saves files in the. You can save any file format that you can open in Excel in the current Excel Workbook file format.
By doing this, you can use the new features of Excel , such as the larger grid, that are not supported by other file formats. Note: When you save a workbook that was created in an earlier version of Excel as an Excel workbook, some formats and features may not be retained.
If you are saving a workbook that was created in an earlier version of Excel, and the workbook contains macros that you want to retain, click. If you are saving a workbook that was created in an earlier version of Excel, the workbook contains macros that you want to retain, and you want to save the workbook as a template, click. For more information about file formats, see File formats that are supported in Excel.
Click the Microsoft Office Button. Get started. Save a workbook in another file format. Open the workbook you want to save. In the Save As dialog box, navigate to the location you want. Convert an Excel workbook to the current file format. Click Convert. In Excel , you can open and save files in the following file formats: Excel file formats Format Extension Description Excel Workbook. Excel Workbook code.
In windows explorer for excel files xls its shows in "type" column "Microsoft Office Excel Worksheet". But for excel file in type column its shows "xlsx file", but in a normal working PC its "Microsoft Office Excel Worksheet".
Search for excel. Try searching and renaming this files. Check if this helps! Was this reply helpful? Note that existing workbook will continue to use its existing file format to save.
How to Save Excel or Workbook as. XLS By Default from. In Office Excel , click on Office button.
0コメント