Office Compatibility Issues

Fix Excel 365 Duplicate Workbook Name Error for an Excel 2003 Macro File

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 870 views

Question details

Open an Excel 97–2003 macro-enabled workbook in Excel 365 without a duplicate workbook name error.

Fix the Duplicate Workbook Name Error for an Excel 2003 Macro File in Excel 365
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.
Before you start

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.

Solution 1Recommended

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.

1
Check open workbooks

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.

2
Look for hidden workbooks

Select View > Unhide, if available, and check whether a hidden workbook has the same name. Unhide and close it before reopening the affected file.

3
Test a different file name

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.

4
Check automatic startup files

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.

Check for an already open workbook with the same name
A renamed copy may not fix the underlying cause: A macro or external link may refer to the original workbook name. If the renamed file opens, check those references before relying on it.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install WPS Office, then launch WPS Spreadsheet.
  2. 2. Open the workbook: Select Open and browse to the Excel workbook you want to review.
  3. 3. Check the workbook: Review the sheets and formulas in WPS Spreadsheet. Test any required macros separately, because VBA support may vary.
Open and review Excel workbooks in WPS SpreadsheetCompatible with common Microsoft Excel formats, including XLS and XLSXFamiliar menus and spreadsheet tools ease migrationFree and lightweight for everyday office tasks
microsoft office alternative - wps office

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.