link -

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!

alt text

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 -
When you run the following code, all previous registered functions in the cache are removed and immediately replaced with the new ones you specify: (context) {        
    return context.sync().then(function(){});

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