Fix Excel 365 Duplicate Workbook Name Error for an Excel 2003 Macro File
Question details
Open an Excel 97–2003 macro-enabled workbook in Excel 365 without a duplicate workbook name error.

- Product
- Microsoft Excel 365 for Business
- Device & OS
- not provided
- Scenario
- A specific Excel 97–2003 (.xls) workbook opens in Excel 2010 and Office 2019 but fails in Excel 365.
- Observed behavior
- Excel 365 displays a message that two workbooks with the same name cannot be opened simultaneously, and the worksheet is grayed out. Other older workbooks and macro-enabled files open normally.
Note the workbook's exact file name and location, and check whether another workbook with that name is already open. Because other macro workbooks work, focus first on this file and any workbook or add-in that may open alongside it.
Check for an already open workbook with the same name
Use this when Excel reports that two workbooks with the same name cannot be open at once.
In Excel, select View > Switch Windows and look for a workbook with the same file name. Close it if it is open, then try File > Open to open the affected file again.
Select View > Unhide, if available, and check whether a hidden workbook has the same name. Unhide and close it before reopening the affected file.
In your file manager, make a copy of the affected .xls file with a different name, then use Excel's File > Open > Browse to open the renamed copy. If it opens, investigate what is opening the original name.
Review workbooks in Excel's XLSTART folder and any configured alternate startup folder. Temporarily move a conflicting startup workbook out of the folder, restart Excel, and try opening the file again.

Test whether startup macros or add-ins cause the conflict
Use this if no duplicate workbook is visible and the problem occurs only with this file.
Run the Excel Compatibility Checker when the workbook opens
Use this to identify workbook features that may not be supported in an older Excel format.
Open Excel Workbooks with WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. It supports common Excel formats, making it easy to move everyday workbook tasks from Microsoft Office. It does not fix Excel 365's duplicate-name error, and VBA macro support may vary.
- 1. Install WPS Office: Download and install WPS Office, then launch WPS Spreadsheet.
- 2. Open the workbook: Select Open and browse to the Excel workbook you want to review.
- 3. Check the workbook: Review the sheets and formulas in WPS Spreadsheet. Test any required macros separately, because VBA support may vary.

Frequently Asked Questions
Why does Excel say two workbooks have the same name?
Excel may already have a workbook with that name open, including a hidden or automatically loaded workbook. Check View > Switch Windows and View > Unhide, then review Excel startup files.
Why is Check Compatibility grayed out?
The command may be unavailable if no workbook is open and active. Open the file in a working Excel installation, select it, and try File > Info > Check for Issues > Check Compatibility.
Should I change my macro security settings?
Not as a first step. Other macro files work in the reported scenario, so check for duplicate names and workbook-specific startup code first. Do not enable macros from an untrusted file.
Does a workbook working in Excel 2019 rule out a VBA issue?
No. Differences in Excel version, 32-bit or 64-bit edition, add-ins, or startup files may affect the result. Compare installations under File > Account > About Excel and review the workbook's VBA code.
Can WPS Spreadsheet run every Excel VBA macro?
Not necessarily. VBA support may vary by WPS version and configuration. Open the workbook in WPS Spreadsheet and test required functionality separately before relying on it.




