Excel officeJs add-in custom function stopped working whenever we deploy new changes on our on-premises server
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?