Stale Data
Summary
Diagnose cases where a worksheet displays old Runline data or an old transformed result.
Symptoms
- Displayed data remains unchanged after the publisher changes.
- A pasted output range differs from the subscribed topic.
- Downstream formulas use old cached or prior values.
Likely Causes
- The visible value is cached, pasted, or RTD-backed rather than directly recalculated.
- The workbook is subscribed to one topic but retrieving or pasting another.
- A dynamic receiving range no longer covers the current data footprint.
Step-by-Step Diagnosis
1. Classify the Value
What to check: Whether the stale cell is direct formula output, RTD output, cached output, or pasted output.
How to check: Inspect the formula in the stale cell and nearby trigger/cache cells.
Expected result: The update path is clear before changing formulas.
2. Trace the Topic
What to check: All formulas address the same report.
How to check: Compare U.SUBSCRIBE, U.GET, U.PASTE, and U.TOPIC inputs.
Expected result: All topic inputs match.
3. Inspect the Receiving Range
What to check: The output area can hold the current result shape.
How to check: Check formulas using U.REGION, U.PAD, U.PASTE, or max row/column parameters.
Expected result: The range covers the current rows and columns without overwriting unrelated cells.
Resolution
Fix topic mismatches first, then refresh or remove stale cache/paste state only for the affected workflow.