Skip to content
REFERENCE

U.TRUSTED_DISTRIBUTOR

Summary

Adds, removes or updates users from whom workbook and/or function distributions will be received

Syntax

=U.TRUSTED_DISTRIBUTOR(excel_instance_id, distributor_username, [workbooks], [functions], [unrestricted])

Parameters

Parameter Required Description
excel_instance_id Yes A code that must be set in order for a trusted distributor to be added or updated. Used to prevent a malicious distributor from adding himself as trusted. Not required when removing a distributor. Set to "CLEAR" to remove trusted distributor(s). Set to TRUE to receive a report of current trusted distributors.
distributor_username Yes The username of the distributor whose workbook and/or function updates will be trusted. If no entity in name then assumed to be the same as the current user. If a 2nd column is provided and set to TRUE then distribution will be trusted even if distributor was not authenticated (not recommended)
[workbooks] No The workbooks that will be received by the trusted distributor. If set to TRUE then all workbooks including macro-enabled (.xlsm, .xlsb) will be trusted. If not set then then all non-macro-enabled workbook updates from the distributor will be trusted
[functions] No The functions that will be received by the trusted distributor. If not set then then all function updates from the distributor will be trusted
[unrestricted] No If set to TRUE then dlls distributed along with functions and .NET namespaces facilitating Web and system access can be used. By default use of library files and .NET classes facilitating Web and system access are blocked

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.TRUSTED_DISTRIBUTOR("NJOOF", "msmith")

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.