Skip to content
REFERENCE

U.TWO_WAY_DATA

Summary

Enables the concurrent updating of a report by multiple users. Users can be other users of the U Add-in for Excel, users of UWeb and/or custom programs connected via an U API

Syntax

=U.TWO_WAY_DATA(report_group, report_name, report_range, [metadata], [controls_or_paste_range], [max_columns], [max_rows], [is_excel_table])

Parameters

Parameter Required Description
report_group No The group of reports to which the report belongs. Can be any name determined by publisher
report_name No The name given to the report. Can be any name determined by publisher, but must be unique within the specified report group
report_range No The range (or ranges if a multi-page report) in Excel that will be published to the specified report topic when its value changes, and to which the report's values will be pasted when an update is made by another user or application
[metadata] No Additional metadata to be applied to report being published. If specified, this metadata is combined with the pub_and_paste metadata into a single list of metadata entries
[controls OR paste_range] No The range into which updates will be pasted if it must be different from the report_range. When publishing an interactive Web report, this range can alternatively contain a list of Web Control indicators
[max_columns] No The max number of columns across which to paste values. By default is set to the width of the corresponding report range. A value of TRUE represents an arbitrarily large number of columns
[max_rows] No The max number of rows in which to paste values. By default is set to the height of the corresponding report range. A value of TRUE represents an arbitrarily large number of rows
[is_excel_table] No If the report range is an Excel table, set this parameter to TRUE otherwise it will be converted into a regular Excel range. Setting the value to 2 will preserve Excel tables, but will paste values as a block which could cause Excel to paste values incorrectly if filters are applied to the table.

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.TWO_WAY_DATA(C97,C98,G97:H101)

=U.TWO_WAY_DATA(,,,,U.WEB_CONTROL_LOCATION(G97:H101,H98:H101))

=IF(ENABLED,U.TWO_WAY_DATA(C11,C12,B20:C28,B15:C18,F21:F26),"Not enabled")

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.