'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Missing XLSX or XLSM Save Options in Excel
Question details
The user is unable to find the standard .xlsx or .xlsm file format options when attempting to save an Excel workbook for an upload.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Saving an Excel workbook in a specific format (.xlsx or .xlsm) to upload it to an examination body.
- Observed behavior
- The required .xlsx and .xlsm formats are missing from the Save As dropdown options, possibly due to legacy file formatting or application compatibility glitches.
Verify whether your workbook contains macros. If it does, you must use the .xlsm format; otherwise, standard workbooks use the .xlsx format.
Use the Advanced 'Save As' Dialog
Manually force the application to show all available file extensions by accessing the traditional Browse dialog in the Save As menu.
Sometimes the quick save menu in newer versions of Microsoft 365 hides older or specific file formats. Using the traditional file explorer window ensures you see the complete list of supported extensions.
Click on 'File' in the top-left corner of the Excel window, then select 'Save As' from the left sidebar.
Click the 'Browse' button (usually indicated by a folder icon) to open the classic Windows or Mac file explorer dialog.
Click the 'Save as type' drop-down menu at the bottom of the window. Scroll through the list and select either 'Excel Workbook (*.xlsx)' or 'Excel Macro-Enabled Workbook (*.xlsm)'.
Choose your destination folder, enter a file name, and click 'Save'.
Transfer Data to a New Blank Workbook
If a specific file is corrupted or stuck in an older compatibility mode, moving the data to a fresh workbook can restore the missing save options.
Upload and Convert via OneDrive
Syncing the file to OneDrive and using Excel for the Web can bypass local software glitches and force a format conversion.
Save and Export Excel Files Easily with WPS Office
If Microsoft Excel is experiencing glitches or preventing you from saving files in required formats, WPS Spreadsheet offers a robust, free alternative. It fully supports standard spreadsheet formats and allows you to save your work without complications.
Frequently Asked Questions
Why are the .xlsx and .xlsm formats missing from my Save As menu?
This typically occurs if the file was originally created in a much older version of Excel (like .xls), generated by a third-party program, or if your Microsoft 365 installation is experiencing a glitch requiring a software repair.
What is the difference between XLSX and XLSM?
XLSX is the default standard format for modern Excel workbooks. XLSM is specifically required for workbooks that contain active macros (VBA code). Saving a file with macros as an XLSX will permanently remove the macro functionality.
Can I simply rename my file extension to .xlsx?
No, manually renaming a file extension in your computer's file explorer does not change the actual file structure. This can corrupt the file or make it unreadable. You must use the 'Save As' function within a spreadsheet application to convert the format.
