Delayed Updates
Summary
Diagnose cases where published or subscribed values update, but later than expected.
Symptoms
- Updates arrive after a noticeable delay.
- A live dashboard updates in batches.
- Publish formulas recalculate more often than subscribers visibly change.
Likely Causes
- Publish throttling, RTD throttling, HTML publish throttling, or scheduled recalculation is intentionally pacing updates.
- Excel calculation mode or expensive workbook formulas are delaying dependent updates.
- Cached intermediate data is being reused longer than expected.
Step-by-Step Diagnosis
1. Identify the Throttle Layer
What to check: Which formula controls update pacing.
How to check: Search the workbook for U.PUB_THROTTLE_MILLIS, U.RTD_THROTTLE_MILLIS, U.RECALC, and U.INCLUDE_HTML.
Expected result: Only the intended layer is throttled.
2. Check Calculation Mode
What to check: Whether Excel is recalculating automatically or on a schedule.
How to check: Review workbook calculation settings and any U.RECALC formulas.
Expected result: The expected ranges recalculate at the expected interval.
3. Check Cache Expiry
What to check: Whether cached values are reused.
How to check: Inspect U.CACHE formulas and expiry inputs.
Expected result: Cache expiry matches the freshness requirement.
Resolution
Tune the narrowest throttle or cache setting that affects the workflow instead of removing all throttling from the workbook.