Skip to content
TROUBLESHOOTING

Delayed Updates

Summary

Published values eventually appear in subscribers, but later than expected. The system is working, but updates are delayed enough to affect usability or confidence.

Symptoms

  • Subscriber values update several seconds late
  • Updates arrive in bursts instead of smoothly
  • Some topics appear current while others lag
  • Excel cells recalculate promptly, but downstream subscribers update slowly

Likely Causes

  • The publisher is not sending updates as frequently as expected
  • Excel recalculation or workbook event flow is delaying outbound updates
  • Network latency or intermittent connectivity is adding delay
  • The subscriber workbook is busy or recalculating slowly
  • High message volume or throttling is causing batching

Quick Checks

  • Confirm the publisher source cells are updating when expected
  • Confirm the subscriber workbook is connected and responsive
  • Test with a simple known-good topic
  • Compare whether the delay is constant or intermittent
  • Check whether only one workbook or all clients are affected

Step-by-Step Diagnosis

1. Verify the publisher is updating on time

What to check: - Whether the source cells or formulas driving the publish are changing when expected

How to check: - Watch the source cells directly in Excel - Force recalculation if appropriate - Compare source update timing with subscriber update timing

Expected result: - The published source values should change at the expected cadence before any downstream delay occurs

If not: - Fix the source data or recalculation timing first - Treat it as an upstream Excel timing issue rather than a publish transport issue

2. Verify the delay is not subscriber-side

What to check: - Whether the subscriber workbook is slow to process or display incoming changes

How to check: - Open a simpler subscriber workbook for the same topic - Check whether the affected workbook is busy recalculating or rendering charts - Compare behavior across multiple subscribers

Expected result: - Multiple subscribers should see similar timing if the delay is upstream

If not: - Optimize the slow subscriber workbook - Reduce expensive formulas, charts, or workbook processing

3. Verify network stability

What to check: - Whether intermittent network issues are delaying message delivery

How to check: - Compare behavior on another network if possible - Check VPN stability if required - Look for patterns such as bursts after brief stalls

Expected result: - The network path should remain stable during the test period

If not: - Resolve the network instability and retest

4. Verify message rate or throttling behavior

What to check: - Whether updates are being intentionally batched, throttled, or suppressed

How to check: - Review relevant configuration for publish frequency or throttling - Test with a lower message rate or smaller set of topics - Compare behavior for high-volume and low-volume scenarios

Expected result: - Update timing should match the configured publish behavior

If not: - Adjust publish cadence or throttling settings as appropriate

5. Verify the issue is not workbook-specific

What to check: - Whether the delay occurs only in one workbook, one machine, or one topic family

How to check: - Test another workbook on the same machine - Test the same workbook on another machine - Test a different topic in the same environment

Expected result: - A platform-wide delay should reproduce consistently across similar scenarios

If not: - Focus troubleshooting on the specific workbook, machine, or topic setup

Resolution

Slow publisher source

  • Reduce delays in the source workbook
  • Fix recalc timing, workbook logic, or event flow issues

Slow subscriber workbook

  • Simplify the subscriber workbook
  • Reduce expensive formulas, charts, or worksheet processing

Network instability

  • Stabilize network or VPN connectivity
  • Retest after the connection path is reliable

Throttling or batching

  • Adjust configuration to reduce batching or lower end-to-end delay
  • Validate that the new cadence meets the use case

Narrow workbook-specific issue

  • Isolate and optimize the affected workbook or topic setup

Edge Cases

  • Excel may update visible cells quickly while chart rendering or workbook event handling lags behind
  • A workbook may appear connected while temporarily stalling under heavy recalculation
  • Small intermittent network stalls can produce bursty downstream updates rather than total failure

Applies To

  • U Toolset
  • U Studio
  • Excel Add-in

Last Updated

2026-03-21