How to Fix Excel Custom ODF Calculation and File-Saving Errors
Question details
The user needs to resolve custom ODF calculation warnings when saving Excel workbooks, find a format supporting AutoSave, identify their Excel version, and fix errors when opening older workbooks stored in OneDrive.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Saving workbooks that contain OpenDocument features and enabling AutoSave via Microsoft 365 cloud services.
- Observed behavior
- Excel displays a warning regarding custom ODF calculations upon saving. Additionally, older files copied to OneDrive fail to open, displaying an error message that the action is only valid for currently installed products.
Before attempting to modify formulas or change file formats, save a local backup copy of your Excel workbook to ensure no data or custom calculations are permanently lost during troubleshooting.
Remove Custom ODF Calculations and Enable AutoSave
Identify and remove unsupported OpenDocument features to eliminate saving warnings, then save in a compatible format to enable AutoSave.
Excel issues this warning when a document contains formulas, named ranges, or links originally associated with OpenDocument (.ods) files that conflict with standard Excel calculations. To enable Microsoft 365 AutoSave, the file must be stored in OneDrive or SharePoint using a supported modern Excel format.
Review your workbook's formulas, named ranges (Formulas > Name Manager), and external data links for any remnants of OpenDocument calculations, and remove or replace them.
Click 'File' in the ribbon, select 'Save As', and choose either 'Excel Workbook (*.xlsx)' or 'Excel Macro-Enabled Workbook (*.xlsm)' from the format dropdown.
Select your OneDrive or SharePoint account as the save location. Once saved to the cloud in a supported format, toggle the 'AutoSave' switch at the top-left corner of the Excel window to 'On'.
Repair Office to Open Older Workbooks
Fix broken file associations and installation errors that prevent older Excel files from opening properly from OneDrive.
Handle ODF and XLSX Files Seamlessly with WPS Office
If Excel continues to throw calculation errors or restrict your saving capabilities, WPS Office offers flawless native compatibility for both OpenDocument (.ods) and Excel (.xlsx) formats. You can edit, auto-save, and convert files without complex warnings.
- 1. Download and Install: Download WPS Office for free from the official website and install it on your device.
- 2. Open the Problematic File: Launch WPS Spreadsheets, click 'Open', and select the workbook triggering the ODF warnings.
- 3. Save as Standard XLSX: Go to 'Menu' > 'Save As' and select 'Microsoft Excel Workbook (*.xlsx)' to automatically clean up compatibility issues.
- 4. Enable WPS Cloud AutoSave: Save the file to WPS Cloud and activate the auto-backup feature to ensure continuous saving.
Frequently Asked Questions
Why does Excel show a custom ODF calculation warning?
This warning appears when a workbook originally created or modified in an OpenDocument format (.ods) contains formulas or features that are not fully supported by standard Microsoft Excel calculations.
Which file format do I need to use for AutoSave in Excel?
To use the AutoSave feature, your workbook must be saved as an Excel Workbook (*.xlsx), Excel Macro-Enabled Workbook (*.xlsm), or Excel Binary Workbook (*.xlsb). Older formats like .xls or .ods do not support AutoSave.
How can I check my exact Excel version and build number?
Open Excel, click on 'File', then select 'Account' at the bottom left. Under 'Product Information', click the 'About Excel' button to view your specific version, build number, and update channel.
How do I fix the 'action only valid for products currently installed' error?
This error usually indicates a broken file association in Windows. You can fix it by opening the Control Panel, navigating to 'Programs and Features', right-clicking your Microsoft Office installation, and running a 'Quick Repair'.
