Excel officeJs add-in custom function stopped working whenever we deploy new changes on our on-premises server

Kishan Vaishnani 6 Reputation points
2024-07-15T07:45:03.8366667+00:00

We created an Excel-based OfficeJs add-in for our client's livestock market streaming application. The add-in is pushed to the app source.

https://appsource.microsoft.com/en-us/product/office/wa200006893?tab=overview

When we deploy fixes or enhancements to our on-premises server, the add-in's custom functions stop working and show NAME? in each cell, the custom functions are in sheets.

We must advise our users to manually clear the office cache before working on the latest version of the add-in It is not possible to take remote sessions with each of our clients to find out what is
causing

https://learn.microsoft.com/en-us/office/dev/add-ins/testing/clear-cache

I have asked question in the Microsoft community portal
https://answers.microsoft.com/en-us/msoffice/forum/all/excel-officejs-add-in-custom-function-stopped/7f993499-5a94-4c69-a9ee-71d33f947eab?rtAction=1721028818585

Could you please suggest solutions?

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,006 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.