VBA User Defined Functions cannot be used with Excel Online or Excel on iOS.
Custom functions are Excel user defined functions that can be used on any platform.
Excel custom functions are not supported in Office 2019 (one-time purchase).
This will refer to the latest production version
The JSON file contains the meta data of the user defined functions.
link - docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-overview
link - docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-json?view=office-js
link - github.com/OfficeDev/Excel-Custom-Functions/issues/
link - youtube.com/watch?v=dtR54AX0zQ0
They can leverage Azure Function calculations in the cloud
To prepare for this change, ensure your custom functions do not use the webpage DOM.
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopNext