Skip to content
HOW TO

Throttle Updates

Goal

Limit update frequency for publish, RTD, or recalculation-heavy workflows.

Prerequisites

  • A measured update path that is too frequent or expensive.
  • A freshness target defining the longest acceptable delay.

Steps

1. Identify which update loop is expensive: publishing, RTD subscription updates, or workbook recalculation.

2. Use the targeted throttle function rather than slowing the whole workbook.

=U.PUB_THROTTLE_MILLIS(500,FALSE)

3. Keep the throttle formula visible and document why the selected interval is acceptable.

Result

The selected update layer runs no more frequently than intended while unrelated workbook calculations remain responsive.

Common Variations

  • Throttle publication without changing RTD delivery.
  • Throttle Runline subscription delivery without changing all Excel RTD sources.
  • Use a numeric block value on supported action functions for per-formula pacing.

Troubleshooting

  • If data is still delayed after removing one throttle, inspect the other layers and Excel calculation mode.
  • If the workbook remains slow, profile the expensive calculation instead of further hiding updates.
  • Avoid stacking several throttles until each layer's effect is understood.