Troubleshooting

link - docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-troubleshooting


Add-in Error No Longer Available

This add-in is no longer available from the following server. 

Check that the manifest file is correct and can be loaded.


Function Returns #BUSY!

Any registered custom functions will get saved and cached by Excel.
When a custom function cannot find its corresponding registration/add-in manifest file it will return #BUSY!
Check that the corresponding manifest file is correct, available and can be loaded.


Function Returns #N/A

This could indicate that the function is (or has been registered) but the corresponding javascript code is not available.
Check the IDs are unique.
Check the IDs in the 'tsx' file correspond to the IDs in the 'json' file.



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