CODEWITHSUNDEEP
exceloffice-jscustom-functions-excel
Will DuCharme
Will DuCharme

Reputation: 21

Excel Custom Functions using Add-Ins: "This add-in is no longer available" error

I followed all of the steps here to try and load in a basic excel custom function add in. Everything in the setup stages seems to work, however, when I run 'npm run start:desktop' and Excel opens, there is an error on the side that says:

ADD-IN ERROR This add-in is no longer available: add-ins inserted during development are only available during debugging from Visual Studio. Please open your project in Visual Studio and re-run your application, or deploy your application into a valid catalog and re-insert

I get this error whether I run the project from the command line, VS Code, or Visual Studio. I am on Windows 10 using Excel 2016.

Here is a photo of the Excel page with the error: enter image description here

Upvotes: 1

Views: 1016

Answers (2)

Kashif
Kashif

Reputation: 105

Even though question is old one and I think OP must have resolved this problem. However I am currently facing the exact same problem so often. Below are my work arounds which are working for me, it might help others.

  1. Clear Excel Cache in Trust center settings and run application again.
  2. Many times options 1 does not work, then I make change in Add-in menifest to make it invalid and then undo these changes and run application.
  3. If both options fails, then restart Visual Studio.
  4. If all other options fails, restart my system, and then this issue is resolved.
  5. If still problem persists, Uninstall Office workload from Visual studio, install it again and check. If problem persists then repair office.

These 5 workarounds have so far worked for me.

Upvotes: 1

Rick Kirkham
Rick Kirkham

Reputation: 9659

Clearing the Office cache sometimes fixes this: Clear the cache

UPDATE 1/23/2021:

There is now a troubleshooting section for this error: Getting error "This add-in is no longer available".

Upvotes: 0

Related Questions