'%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)
Fix Excel Cannot Validate an Excel 97-2003 Workbook Error
Question details
Users are unable to validate Excel 97-2003 workbooks, resulting in unsaved changes, inaccessible CSV files, and VBA macro failures.
- Product
- Microsoft 365 Excel
- Device & OS
- not provided
- Scenario
- Saving, validating, or running VBA macros on a legacy Excel 97-2003 (.xls) workbook using a modern version of Microsoft 365 Excel.
- Observed behavior
- Microsoft 365 Excel displays warnings that workbook changes were not saved, a CSV file could not be accessed or uploaded, and triggers runtime error 1004 related to the Range method.
Ensure you have full read and write permissions for the folder where the workbook is located, and verify that the file is not currently open in another application.
Convert Workbook to a Modern Excel Format
Upgrading your outdated Excel 97-2003 (.xls) format to a modern .xlsx or .xlsm format resolves most compatibility and validation limit errors.
The legacy Excel 97-2003 format is heavily restricted (e.g., maximum 65,536 rows). Modern validation tools and VBA scripts referencing larger ranges will fail in this format.
Launch Microsoft Excel and open the problematic Excel 97-2003 workbook.
Click on 'File' in the top-left corner of the Excel ribbon and select 'Save As' from the sidebar.
Choose a destination folder, click the 'Save as type' dropdown menu, and select 'Excel Workbook (*.xlsx)'. If your workbook contains macros, select 'Excel Macro-Enabled Workbook (*.xlsm)' instead.
Click 'Save'. Close the file and reopen the new modern version, then attempt the validation process again.
Verify CSV File Paths and Permissions
Ensure the directory where your CSV upload files are generated is fully accessible and that the file path strings are correct.
Troubleshoot Runtime Error 1004 in VBA
Fix validation codes triggering runtime error 1004 by ensuring the Range object is properly referenced and stays within legacy limits.
Handle Legacy Excel Files Smoothly with WPS Office
If Microsoft 365 struggles to validate or process your older Excel 97-2003 workbooks, consider using WPS Office. It provides excellent backward compatibility for legacy .xls files and is a highly compatible, free alternative to Microsoft Office.
- 1. Download WPS Office: Download and install WPS Office for free from the official website.
- 2. Open the legacy file: Launch WPS Spreadsheets and open your Excel 97-2003 workbook without compatibility warnings.
- 3. Process and save securely: Easily run your data validation and natively save back to .xls or upgrade to .xlsx flawlessly.
Frequently Asked Questions
Why do I get Runtime Error 1004 when validating an Excel 97-2003 file?
This runtime error typically occurs if your macro or validation process tries to reference cells outside the boundaries of the legacy format, which is strictly limited to 65,536 rows and 256 columns.
How can I fix the 'CSV file could not be accessed' warning?
This warning means Excel is blocked from saving or reading the generated file. Check if the CSV is already open in another program, verify that your folder allows write permissions, and ensure your antivirus isn't blocking the action.
Are Excel 97-2003 workbooks still fully supported in modern Excel?
While modern Excel versions can still open and save .xls files, some new features, complex arrays, and validation tools are not compatible with this outdated format. It is highly recommended to convert files to the modern .xlsx format for full functionality.
