Fix Excel Cannot Save Workbook as XLSX Due to Excel 4.0 Functions
Question details
The user needs to save a Microsoft Excel workbook in .xlsx format, but Excel blocks the save because the file contains Excel 4.0 functions stored in defined names.
- Product
- Microsoft Excel workbook / WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user opened an existing workbook that previously saved successfully and now tries to save it in the macro-free XLSX format.
- Observed behavior
- Excel displays a compatibility or save error and does not complete the XLSX save until the Excel 4.0 functions or macro modules are removed, or the file is saved as .xlsm.
Confirm whether the workbook still needs macros or Excel 4.0 functions. If any calculation depends on those defined names, choose the XLSM format; otherwise you can remove the unsupported content before saving.
Remove Unsupported Excel 4.0 Functions or Macros and Save as XLSX
Use this solution when the workbook does not need macros or legacy Excel 4.0 functions and you want to save it as a standard .xlsx file.
Excel 4.0 functions are stored in defined names and are not supported in the .xlsx format. Removing them is appropriate only when the workbook no longer needs those legacy macro calculations.
In Excel or WPS Spreadsheets, press Alt+F11 to open the Visual Basic Editor.
In Project Explorer, expand the Modules folder, right-click the module such as Module1, select Remove Module, and choose No when prompted to export.
Close the editor and open Formulas > Name Manager. Select each defined name that uses an Excel 4.0 function, click Delete, and confirm.
Click File > Save As, choose Excel Workbook (*.xlsx), select a location, and click Save.
Save the Workbook as XLSM When Macros Must Be Kept
Use this solution when the workbook still needs macros or legacy Excel 4.0 functions and you cannot remove them.
Fix Excel 4.0 Function Save Error with WPS Spreadsheets
Open the affected workbook in WPS Spreadsheets, remove the unsupported Excel 4.0 names or macro modules, and save the file as a clean .xlsx file. WPS Office supports Microsoft Excel formats and gives you a familiar ribbon interface for the same workflow.
- 1. Open the affected workbook: Launch WPS Office, click File > Open, and open the Excel workbook that cannot be saved as XLSX.
- 2. Remove macro modules: Press Alt+F11 to open the Visual Basic Editor. Expand Modules, right-click the macro module, and choose Remove Module to delete it.
- 3. Clean up Excel 4.0 defined names: Close the editor and click the Formulas tab > Name Manager. Select any defined name that uses an Excel 4.0 function, click Delete, and confirm.
- 4. Save as XLSX: Click File > Save As, choose Excel Workbook (*.xlsx), pick a save location, and click Save.
Frequently Asked Questions
Why does Excel stop me from saving an XLSX file when Excel 4.0 functions are present?
XLSX is a macro-free format, and Excel 4.0 functions in defined names are considered macro content. You must remove those defined names or save the workbook as .xlsm.
How can I locate Excel 4.0 functions inside defined names?
Open Formulas > Name Manager and inspect the Refers To field for Excel 4.0 function names such as EVALUATE, CALL, REGISTER, or other macro-type formulas. Select and delete any names that are not needed.
Will saving as XLSM keep my macros working?
Yes. In File > Save As, choose Excel Macro-Enabled Workbook (*.xlsm) to keep VBA macros and Excel 4.0 functions, then test the workbook after reopening.
Can I remove a VBA module and then save the file as XLSX?
Yes. Press Alt+F11 to open the Visual Basic Editor, remove the unnecessary module, close the editor, and use File > Save As > Excel Workbook (*.xlsx).
Does WPS Office support saving workbooks as XLSX and XLSM?
Yes. WPS Spreadsheets can save in Microsoft Excel Workbook (*.xlsx) and Excel Macro-Enabled Workbook (*.xlsm) formats while preserving compatibility with Microsoft Excel.
