Skip to content
REFERENCE

U.ADDINS

Summary

If present in a workbook, installed or un-installs the specified add-in. Also supports blacklisting add-ins as well as returning a report showing the names and paths of all add-ins

Syntax

=U.ADDINS(add_in_or_show_all, install, [block])

Parameters

Parameter Required Description
add-in OR show_all Yes The name or full path of the add-in to be added or removed. If not set then a report of installed add-ins is returned; if set to TRUE then a report of all known add-ins is returned whether installed or not. For blacklists multiple values are accepted or "clear" to clear blacklist.
install Yes Set to TRUE to have specified add-in installed; set to FALSE to have specified add-in uninstalled. Set to "blacklist" to set or clear items from the add-in blacklist
[block] No If set to TRUE then method will not be calculated unless triggered by user interaction or calculated as a step in a script; If set to a number then will be throttled to not calculate more frequently than the specified number of seconds; make number negative to prevent auto recalc of blocked methods

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.ADDINS(B50,C50)

=U.ADDINS(B54:B55,"blacklist")

=U.PAD(U.ADDINS())

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.