Skip to content
TROUBLESHOOTING

Publish Not Working

Summary

Data published from Excel does not appear in one or more subscribers, even though the publisher workbook appears to be running normally.

Symptoms

  • A subscriber workbook does not receive expected updates
  • The publisher workbook appears connected, but no data arrives downstream
  • A publish formula or action appears to complete without an obvious error
  • Some topics update, but others do not

Likely Causes

  • The publisher and subscriber are using different topic names
  • The connection to the server is not active
  • There is no active subscriber for the published topic
  • The publish source value is blank, invalid, or not changing as expected
  • A firewall, proxy, or environment mismatch is preventing data flow

Quick Checks (1–2 minutes)

  • Confirm the publisher workbook is connected
  • Confirm the subscriber workbook is connected
  • Confirm the topic strings match exactly
  • Confirm the subscriber is pointed at the expected environment
  • Confirm the source cell or formula is producing the value you expect

Step-by-Step Diagnosis

1. Verify connection

What to check:

  • Whether the publisher workbook is connected to the expected server or environment
  • Whether the subscriber workbook is also connected

How to check:

  • Check the add-in connection status in Excel
  • Confirm the configured host, port, or environment matches what you expect
  • If your setup exposes connection state in a worksheet formula or status area, verify it shows connected

Expected result:

  • Both publisher and subscriber should show an active connection to the same environment

If not:

  • Reconnect the workbook
  • Correct the environment or server configuration
  • See Cannot Connect

2. Verify the topic name

What to check:

  • Whether the exact topic string used by the publisher matches the topic string used by the subscriber

How to check:

  • Compare the full topic values side by side
  • Check capitalization, separators, spaces, report group names, entity prefixes, and month or symbol identifiers
  • If topic values are formula-driven, inspect the underlying cells that construct the topic

Expected result:

  • The publisher and subscriber should use the exact same topic string

If not:

  • Correct the topic mismatch
  • Standardize topic construction so both sides derive from the same components

3. Verify a subscriber is active

What to check:

  • Whether at least one subscriber workbook or consumer is actively listening for the topic

How to check:

  • Open a known-good subscriber workbook for the same topic
  • Confirm the subscriber formula or subscription is present and recalculating
  • If available, check any subscriber count or diagnostic logging

Expected result:

  • At least one subscriber should be actively connected and subscribed to the topic

If not:

  • Start a subscriber workbook
  • Confirm the subscription is correctly configured
  • Retest after the subscriber is connected

4. Verify the source data is actually changing

What to check:

  • Whether the source cell, formula, or code path driving the publish is producing a valid value

How to check:

  • Inspect the source cells directly in Excel
  • Force a recalculation if appropriate
  • Confirm the value is not blank, stale, error-valued, or filtered out by business logic

Expected result:

  • The publish source should contain the expected value and should update when the input changes

If not:

  • Fix the source formula or data dependency
  • Confirm the publish is bound to the intended source cell or range

5. Verify the issue is not environment-specific

What to check:

  • Whether publisher and subscriber are pointed at different servers, tenants, or environments

How to check:

  • Compare connection settings across both workbooks
  • Check entity prefixes, deployment targets, or environment labels
  • Test with a known-good topic in the same environment

Expected result:

  • Both sides should be connected to the same environment and using the expected entity/topic namespace

If not:

  • Repoint one side so both are aligned
  • Retest with a simple known-good topic

Resolution

Topic mismatch

  • Make the publisher and subscriber use the exact same topic string
  • Prefer deriving topic strings from shared inputs rather than manual typing

No subscriber running

  • Start a subscriber workbook or consumer for the topic
  • Confirm the subscription remains active during testing

Connection problem

  • Reconnect the workbook
  • Verify host, port, credentials, and environment settings
  • See Cannot Connect

Invalid or stale source data

  • Fix the source formula, refresh the source data, or force recalculation as appropriate
  • Confirm the publish is reading from the intended source range

Environment mismatch

  • Ensure both workbooks are pointed at the same environment
  • Verify entity prefixes and topic namespaces are aligned

Edge Cases

  • A topic may appear correct but differ by a small formula-generated suffix or prefix
  • A workbook may be connected, but connected to the wrong environment
  • A publish may be suppressed by logic intended to avoid sending unchanged or invalid values
  • Some issues only affect one topic family because of report-group or namespace differences

Applies To

  • U Toolset
  • U Studio
  • Excel Add-in

Last Updated

2026-03-21