Skip to content
HOW TO

Subscribe to Data in Excel

Goal

Subscribe an Excel workbook to live updates from a Runline report.

Prerequisites

  • The report group, report name, and environment used by the publisher.
  • A connected and authenticated Runline U session.
  • A clear cell for the RTD subscription and a separate output area for report data.

Steps

1. Use the same report group, report name, metadata, and environment expected by the publisher.

=U.SUBSCRIBE($B$2,$B$3,,,$B$4)

2. Place the subscriber formula in a stable cell and keep downstream formulas separate from the subscription registration.

3. Use U.GET or U.PASTE when the receiving range needs the current report body rather than just the live notification value.

Result

The subscription cell changes when report updates arrive; dependent retrieval formulas can then display the current report body.

Common Variations

  • Pass a full topic instead of separate group and report-name inputs.
  • Subscribe to a cache key by passing the key as the single identifying input.
  • Use auto-subscribe only for function-channel topics and review its architecture-specific options.

Troubleshooting

  • If the subscription never changes, check connection status and topic identity.
  • If notifications arrive but data remains old, inspect the dependent U.GET or paste range.
  • If updates are batched, review RTD and subscription throttling.