Fixing “Excel Cannot Find the Add-In ‘X’. Delete from List?”

The prompt “Excel cannot find the add-in ‘[Filename.xlam]’. Delete from list?” appears when Excel tries to load an Excel Add-in (.xla, .xlam) registered in its startup checklist, but the file has been moved, renamed, deleted, or stored on an inaccessible network drive.

Clicking “Yes” simply removes the entry from your available add-ins list, while clicking “No” leaves the entry intact—causing the error to return the next time Excel starts.

Quick Answer

If you no longer use the add-in: Click Yes when the prompt appears. Excel will prune the missing path from its configuration and stop asking.

If you still need the add-in: Click No. Go to File > Options > Add-ins, select Excel Add-ins from the Manage drop-down, and click Go. Click Browse…, locate the file in its new folder, select it, and click OK. Excel will update its stored path to the new location.

---

Why the Prompt Appears

Excel Add-ins (unlike COM add-ins) are tracked in the Windows Registry under a series of string values named OPEN, OPEN1, OPEN2, and so forth, located at:
HKEY_CURRENT_USER\Software\Microsoft\Office\<version>\Excel\Options

When Excel initializes, it steps through each OPEN key in sequence and attempts to load the file path stored inside it. The error prompt triggers under four scenarios:

1. File Cleanup: You downloaded an add-in into your Downloads folder, enabled it, and later cleaned out your downloads.
2. Network/Cloud Drive Latency: The add-in is saved on a shared corporate network drive (S:\...) or a sync client (OneDrive, SharePoint) that has not yet mounted or authenticated when Excel boots.
3. Drive Letter Mapping Changes: An IT update remapped a network location from drive H:\ to P:\, invalidating the hardcoded path.
4. Excel Version Migrations: Upgrading Office imported the registry options from an older version, but the local user path changed.

---

Step-by-Step Resolution Procedures

Use the following methods depending on whether you want to permanently remove the missing add-in or restore it.

Method 1: Clean Removal via the Add-ins Manager

If you have already deleted the file or uninstalled the software:

1. Open Excel and launch a blank workbook.
2. If the warning dialog appears, click Yes. In many cases, this completely resolves the issue.
3. If the prompt still appears on the next boot:
   • Go to File > Options > Add-ins.
   • In the Manage drop-down at the bottom, ensure Excel Add-ins is selected, then click Go…
   • In the Add-ins dialog, click the checkbox next to the ghost add-in.
   • Excel will display the prompt: “Cannot find add-in ‘[Name]’. Delete from list?”
   • Click Yes.
   • Click OK to close the window and save the updated list.

File > Options > Add-ins
  └── Manage: Excel Add-ins [Go...]
        └── Check the box of the missing add-in
              └── Prompt: "Delete from list?" -> Click [Yes]

Method 2: Restoring and Relinking the Add-In

If you want to keep the add-in, move it to the recommended local directory first so it is protected from accidental deletion:

1. Move your .xlam file into the official Microsoft Excel Add-ins directory:
   C:\Users\<Username>\AppData\Roaming\Microsoft\AddIns(This folder is the protected default home for custom add-ins and is rarely affected by system cleanup tools).
2. Open Excel. When the error prompt appears, click No.
3. Navigate to File > Options > Add-ins.
4. Set the Manage drop-down to Excel Add-ins and click Go…
5. Click the Browse… button.
6. The Browse window opens directly to your AppData\Roaming\Microsoft\AddIns folder. Select your moved .xlam file and click OK.
7. Ensure the box next to your newly mapped add-in is checked, then click OK.

Method 3: Clearing Stubborn Registry Keys

If clicking “Yes” fails to remove the add-in—or if the prompt returns on every single reboot despite being deleted from the UI—the add-in’s path is locked in an abandoned registry flag or governed by a Group Policy setting.

Caution: Make a backup before modifying registry values. A typo in the registry can affect other application settings.

1. Close Excel.
2. Press Win + R, type regedit, and hit Enter.
3. Navigate to the Excel Options path for your installed Office version:
   • Microsoft 365 / Office 2019 / Office 2016:HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options
   • (For Office 2013, change 16.0 to 15.0; for Office 2010, change to 14.0)
4. In the right-hand pane, look for String Values named OPEN, OPEN1, OPEN2, etc.
5. Inspect the Data column for these entries. Locate the entry that contains the path to the missing add-in file.
6. Right-click the offending OPEN key and select Delete.
7. Important: If you have multiple OPEN entries (e.g., OPEN, OPEN1, OPEN2), ensure the remaining numeric sequence has no gaps. For example, if you delete OPEN1, rename OPEN2 to OPEN1. If a gap remains in the sequence, Excel will stop reading the add-in list at the gap, which will disable any subsequent add-ins.
8. Close the Registry Editor and relaunch Excel.

---

Handling Network and Cloud Storage Traps

If the missing add-in is stored on a shared network drive or cloud folder:

• VPN Requirements: If your company stores add-ins on an internal server (such as \\corp\files\addins\), launching Excel before connecting to your corporate VPN causes Excel to check the path, fail, and trigger the “Cannot find” prompt. Move a copy of the add-in to your local hard drive (%APPDATA%\Microsoft\AddIns) and link it locally instead of over the network.
• OneDrive “Files On-Demand”: If an add-in is stored in a synced OneDrive folder, the operating system may unhydrate the file to save disk space, leaving it as an online-only placeholder. When Excel tries to open the file at startup, it cannot read the code in time. Right-click the folder containing your add-ins inside File Explorer and select Always keep on this device to ensure the physical binary is always available locally.