Caching

link - docs.microsoft.com/en-us/office/dev/add-ins/testing/clear-cache


Functions Are Cached

Any registered custom functions will get saved and cached by Excel.
This caching means that the function names are visible even when the add-in is not loaded.
When a custom function is triggered Excel will load the corresponding add-in automatically.
If the corresponding add-in cannot be loaded then you will see this error message:
Once this task pane has been closed these functions will return #BUSY!


Clearing the Cache

It is possible to manually clear the Excel cache by deleting the following folder:

C:\Users\"user name"\AppData\Local\Microsoft\Office\16.0\WEF\CustomFunctions 

Previously Registered

link - stackoverflow.com/questions/47393203/how-to-reload-excel-custom-functions
When you run the following code, all previous registered functions in the cache are removed and immediately replaced with the new ones you specify:

Excel.run(function (context) {        
    context.workbook.customFunctions.addAll();
    return context.sync().then(function(){});
}).catch(function(error){});



© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext