Skip to content
TROUBLESHOOTING

Stale Data

Summary

Displayed values remain unchanged even though the user expects fresh data. The issue may come from the source workbook, the publish flow, the subscriber, or the user viewing the wrong environment or topic.

Symptoms

  • A value remains frozen while the market or source data should be changing
  • One topic appears stale while others continue to update
  • A workbook shows old values after reconnecting
  • The displayed value is valid, but clearly out of date

Likely Causes

  • The source workbook is no longer refreshing its data
  • The publish flow is not sending new values
  • The subscriber is still pointed at an old topic or environment
  • The displayed value is cached or no longer recalculating
  • The user is looking at a valid but inactive source

Quick Checks

  • Confirm the source value is actually changing
  • Confirm the publisher and subscriber are connected
  • Confirm the topic and environment are correct
  • Force recalculation or refresh in the workbook
  • Compare against a second known-good workbook or source

Step-by-Step Diagnosis

1. Verify the source value is changing

What to check: - Whether the original source workbook or formula is producing fresh values

How to check: - Inspect the source cells directly - Refresh the source data if applicable - Compare timestamps or related changing fields if available

Expected result: - The source value should be changing when the underlying data changes

If not: - Fix the upstream source or refresh process first - Do not treat it as a downstream subscription issue yet

2. Verify the publish path is active

What to check: - Whether fresh source values are being sent out after they change

How to check: - Test a simple known-good topic - Compare the source cell to a subscriber watching the same topic - Confirm the publish logic is still attached to the intended source

Expected result: - Fresh source changes should propagate to subscribers shortly after the source updates

If not: - Investigate the publish configuration or logic - See Publish Not Working

3. Verify the subscriber is using the correct topic and environment

What to check: - Whether the subscriber is pointed at the intended topic in the intended environment

How to check: - Compare the topic string character by character - Confirm the environment or server settings - Compare against another workbook known to receive fresh values

Expected result: - The subscriber should be connected to the correct topic in the correct environment

If not: - Correct the topic or environment mismatch

4. Verify recalculation or refresh on the subscriber side

What to check: - Whether the subscriber workbook is recalculating and updating displayed values

How to check: - Force recalculation if appropriate - Check whether the workbook is in a mode that delays visible updates - Test in a simpler workbook with fewer calculations or charts

Expected result: - Fresh incoming data should be reflected in visible worksheet values

If not: - Resolve workbook-side recalculation or rendering delays

5. Verify the value is not legitimately inactive

What to check: - Whether the data source or topic is simply not changing at this time

How to check: - Compare against an independent source - Test another active topic known to update frequently - Review whether the selected instrument, topic, or scenario is expected to be quiet

Expected result: - Active topics should show current movement or fresh timestamps when expected

If not: - Switch to a known active topic for comparison - Confirm expectations before treating the behavior as an error

Resolution

Source is not refreshing

  • Restore the source data refresh process
  • Fix upstream formulas, feeds, or workbook refresh logic

Publish path inactive

  • Reconnect, rebind, or repair the publish setup
  • Validate with a simple known-good topic

Wrong topic or environment

  • Correct the topic string and environment configuration
  • Retest after reconnecting

Subscriber workbook not updating visibly

  • Force recalculation or simplify workbook processing
  • Remove workbook bottlenecks that delay visible updates

Inactive but valid source

  • Confirm the selected topic is expected to move
  • Use a known active comparison topic

Edge Cases

  • A stale-looking value may actually be current if the selected topic is inactive
  • A workbook may reconnect successfully but remain pointed at an outdated environment
  • Cached display behavior can make one sheet appear stale even while another part of the workbook is current

Applies To

  • U Toolset
  • U Studio
  • Excel Add-in

Last Updated

2026-03-21