Excel prompts to install an already installed add-in after reinstallation

[irynakaban]

After reinstalling Script Lab, Excel incorrectly prompts to install the add-in again when registering a formula, even though it is already installed.

Your Environment

• Platform [PC desktop, Mac, iOS, Office on the web]: Mac
• Host [Excel, Word, PowerPoint, etc.]: Excel
• Office version number: 16.93.1 (25011917)
• Operating System: 15.2 (24C101)

Expected behavior

When reinstalling Script Lab and registering a formula, Excel should recognize that the add-in is already installed and not prompt the user to install it again.

Current behavior

After reinstalling Script Lab, Excel incorrectly prompts the user to install the add-in when registering a formula, even though the add-in is already installed.

Steps to reproduce

1. Install Script Lab from store.
2. Register a formula in Script Lab.
3. Add formula to worksheet.
4. Save workbook.
5. Uninstall Script Lab.
6. Close the workbook.
7. Reopen the previously saved workbook in Excel.
8. Excel will prompt you to install the missing add-in. Close this prompt.
9. Install Script Lab from store,
10. Register formula. Excel incorrectly prompts you to install the add-in, even though it is already installed.

Provide additional details

1. Link to video on Google Drive

Context

Users of our add-in have also encountered the same issue and a similar issue when their workbook’s webextension1.xml file contains the following references:

<we:reference id="guid id from our manifest" version="1.8.0.0" store="EXCatalog" storeType="EXCatalog"/>  
<we:alternateReferences>  
  <we:reference id="id from store" version="1.8.0.0" store="en-US" storeType="OMEX"/>  
</we:alternateReferences>

When these references are present, formulas freeze in busy and stop working properly and context.application.calculate(Excel.CalculationType.full) doesn't work.

[microsoft-github-policy-service]

Thank you for letting us know about this issue. We will take a look shortly. Thanks.