How to update a Visio flowchart from Excel

The short version

• Data Visualizer: Data Tools Design tab, visible only with the container selected. Refresh Diagram pulls in, Update Source Data pushes back.
• Linked data: Data tab, Refresh Data or Refresh All. One-way only: Microsoft says the source cannot be updated from the diagram.
• Formulas in the Excel source do not survive a write-back; Visio converts each formula to its result.
• Make the source an Excel Table, not a custom range, if you want the diagram and data to stay synchronised.
• Both mechanisms are desktop features: data-connected diagrams cannot be edited in Visio for the web.

Two mechanisms, one of them one-way

Before you refresh anything, establish which of Visio's two Excel mechanisms your diagram actually uses, because they behave in opposite directions. A diagram produced by a Data Visualizer template is refreshed from the Data Tools Design ribbon tab, which appears only once you click inside the diagram container: Refresh Diagram pulls Excel changes in, and Update Source Data pushes diagram changes back out. A diagram built by linking a workbook to shapes you drew yourself is refreshed from the Data tab, with Refresh Data or Refresh All, and Microsoft states flatly that "You cannot update the data source to which a Visio diagram is linked by making changes in the Visio diagram." Same product, same workbook, entirely different contract.

The Data Visualizer side is the two-way one, and Microsoft documents it as such: "Visio also supports two-way synchronization between the Visio diagram and the Excel workbook." Refresh is scoped to the container ("Refreshing only makes changes to the shapes and connections inside the container"), and it is careful with your work, because "Any formatting changes you make to the shapes or connectors inside the container are preserved." Where a refresh would discard something, a "Refresh Diagram Conflict" dialog appears first. Writing back has two conditions: the workbook must be saved and closed if it lives on a desktop machine or a network file server, and an "Update Source Data Conflict" dialog will ask you to select "Overwrite". The templates themselves are documented as Visio Plan 2 only.

The linked-data side draws no connectors and never writes back. It is the Data tab route described in /guides/how-to-import-excel-data-into-visio, and the External Data window holds "a snapshot of your source data at the time of import", so refreshing is how you replace that snapshot. Rows added to or deleted from the source do not silently restructure the drawing: they raise a "Refresh Conflicts" pane, resolved with Delete Shape, Delete All Listed Shapes, Keep Shape, Keep All Listed Shapes, Select Matching Row or Ignore All Conflicts. Matching depends on the unique identifier chosen at import, on the wizard's "Configure Refresh Unique Identifier" page. Both routes are desktop features: Microsoft lists diagrams connected to Excel among those that cannot be edited in Visio for the web.

The worked example below is a churn-risk review, a process whose thresholds, owners and escalation rules genuinely change every quarter, which is exactly the case that makes refresh worth understanding rather than skimming. It is built in QueryChart, where the rows are the diagram rather than a source the diagram was generated from, so there is no refresh command, no conflict dialog and no write-back for a formula to be flattened by. That is the whole of QueryChart's claim on this page, and it is worth exactly one paragraph: if Visio is what your organisation runs, the procedure above is the answer, and the pitfalls after the example are the four ways teams lose data to it.

The same process without a refresh step

A churn-risk review built in four stages, where editing the rows is editing the diagram: watch the spreadsheet columns fill in beneath it.

1. The recurring run and its first threshold

   "Refresh the churn-risk dataset" opens a cycle rather than a line, and "Keep the account on the watchlist" sends accounts below the intervention threshold straight back to "Score every account against the churn-risk model" on an arrow labelled Next refresh. A loop like that is ordinary process logic here: no mechanism has to be told the arrow points backwards.

2. Connections as row numbers

   Once the Line to column is filled in, "Publish the at-risk queue with its risk drivers" leads into review and "Is the leading driver commercial or product-related?" forks into two different owners. This column is the equivalent of Data Visualizer's Next Step ID, except that changing it changes the drawing immediately rather than at the next refresh.

3. Labelled branches on every decision

   "Commercial" and "Product-related" appear on the arrows out of row 7, and "Re-engaged" and "No re-engagement" on the arrows out of "Has the account re-engaged above the recovery threshold?". Branch labels are a column, matched positionally to the row numbers beside them, so they cannot drift away from the branch they describe.

4. Owners, and the escalation that loops back

   The lane columns place each step with Data and analytics, Customer success, the Account manager or Product, and the last decision ("Is the account recoverable before renewal?") sends a recoverable account back to "Contact the customer and agree an action plan" for a second attempt. Recalibrating the threshold next quarter is an edit to one cell, with no diagram to bring back into line afterwards.

How it works

1. Work out which mechanism you are looking at

   Click inside the diagram. If a container appears around the flow and a Data Tools Design tab appears on the ribbon, this is a Data Visualizer diagram and refresh is two-way. If there is no container and the Excel columns are visible in the External Data window on the Data tab, the workbook is linked to shapes and refresh is one-way. Everything below depends on which of the two you have; the commands are not interchangeable.

2. Pull Excel changes into a Data Visualizer diagram

   Edit and save the workbook, then, in Microsoft's own words: "In Visio, click in the diagram container to enable the Data Tools Design tab in the ribbon, and then select Refresh Diagram." The refresh is scoped to the container, so shapes you added outside it are untouched, and formatting you applied to shapes and connectors inside it is preserved. The ability to use the Data Visualizer templates is documented as Visio Plan 2 only.

3. Answer the Refresh Diagram Conflict dialog

   If the incoming data would discard something you changed in the diagram, Visio opens a "Refresh Diagram Conflict" dialog before it commits. Read it rather than clicking through it: this is the one moment where you are told, in advance, that the workbook and the drawing disagree. Resolve it, then check the shapes you know were edited by hand.

4. Push diagram changes back with Update Source Data

   With the container still selected, Update Source Data on the Data Tools Design tab writes the diagram's changes into the workbook. Two conditions apply: the workbook must be saved and closed if it lives on a desktop machine or a network file server, and where data may be lost an "Update Source Data Conflict" dialog appears, in which you select "Overwrite". This command has no equivalent on the linked-data route.

5. Refresh a linked-data diagram from the Data tab

   For shapes linked to a workbook, use Refresh Data, or Refresh All for every connection in the file. Values inside the existing shapes update; the drawing's structure does not. Rows added to or removed from the source open the "Refresh Conflicts" pane, where each mismatch is resolved with Delete Shape, Delete All Listed Shapes, Keep Shape, Keep All Listed Shapes, Select Matching Row or Ignore All Conflicts.

6. Schedule the linked-data refresh if the source changes on a cadence

   This one belongs to the linked-data route: on the desktop, open the Refresh Data dialog, tick "Show this dialog box on file open", then select Configure and set Automatic Refresh; the Configure Refresh dialog lets you "select the Refresh every check box, and then click the arrows to choose an interval". Microsoft documents no equivalent schedule for Refresh Diagram, so on the Data Visualizer route the refresh stays a command somebody has to remember, which is how a diagram quietly falls a quarter behind the data it claims to show.

Mistakes to avoid

• Formulas in the Excel source are destroyed by the write-back

  Microsoft's instruction is unambiguous: "Do not use formulas in the Excel data source. After you select Overwrite in the Update Source Data dialog box, Visio converts the formula to the formula result." A process table that computes anything (a step count, a concatenated step ID, a lookup of the owning team) loses the computation the first time somebody edits the diagram and pushes back, and what remains looks correct. Keep derived values in a separate workbook, or accept that the table is hand-typed.

• Assuming both refreshes restructure the diagram, or that neither does

  This is where the two mechanisms diverge most and get conflated most. Refresh Diagram does rebuild structure, but only within its own boundary: "Refreshing only makes changes to the shapes and connections inside the container." Linked data does not rebuild structure at all: Microsoft's wording for an org chart is that "the data is updated normally when you run Refresh Data, but only inside existing shapes", and "Refreshing the data does not add or remove shapes", with added and deleted rows raising the Refresh Conflicts pane instead. So a rewritten process regenerates on the Data Visualizer route and has to be rebuilt on the linked-data one; /guides/how-to-create-org-chart-from-excel-in-visio covers what that means for a re-org.

• No unique identifier, so rows cannot be matched to shapes

  Reliable refresh depends on the identifier chosen at import, on the "Configure Refresh Unique Identifier" page. Microsoft's prep rule is to "make sure that one column of your data contains unique values for each row, and that the values match the text on the shapes". Data Visualizer is stricter still: every value in the Process Step ID column "must be unique and not be blank". Without that column, refresh has nothing to match on and the results are arbitrary.

• Pointing the wizard at a custom range instead of an Excel Table

  The Create Diagram from Data wizard accepts "a table or a custom range in the workbook", and choosing the range opts you out of synchronisation from the outset. Microsoft's guidance is to "Use an Excel table and not a custom range if you want to keep your diagram and data synchronized". This one is decided at creation time, so a diagram that will not refresh properly usually has to be recreated rather than repaired.

Keep this process without a refresh step

Open the churn-risk review as your own chart and change a threshold: the diagram is the rows, so there is nothing to refresh afterwards.

Keep this process without a refresh step

Related guides

• Visio Data Visualizer add-in retired: what to use instead
• Visio Data Visualizer migration guide
• How to create a flowchart from Excel in Visio

Frequently asked questions

Does a Visio flowchart update automatically when I change the Excel file?

Not by default: refresh is a command you run. For a Data Visualizer diagram, click inside the diagram container to reveal the Data Tools Design tab and select Refresh Diagram. For shapes linked to a workbook, use Refresh Data or Refresh All on the Data tab. The desktop app can automate the second case: in the Refresh Data dialog, tick "Show this dialog box on file open", then select Configure and set Automatic Refresh, where you can choose an interval. Until you do one of those things, the diagram shows the data as it was when it was last refreshed.

Can I edit the Visio diagram and have the changes go back into Excel?

Only on the Data Visualizer route. There, Update Source Data on the Data Tools Design tab writes the diagram's changes into the workbook, which Microsoft describes as "two-way synchronization between the Visio diagram and the Excel workbook"; the workbook must be saved and closed if it is on a desktop machine or network file server, and an "Update Source Data Conflict" dialog asks you to select "Overwrite". For shapes linked with Link Data to Shapes, it is impossible: "You cannot update the data source to which a Visio diagram is linked by making changes in the Visio diagram."

Why has my Refresh Diagram button disappeared?

Two things worth checking. Data Tools Design is a contextual tab: it appears only once the diagram container itself is selected, so clicking a single shape is not enough. Separately, if your diagram lived inside Excel rather than Visio, you were using the Visio Data Visualizer add-in for Excel: Microsoft announced its retirement in November 2025 and set the service shutdown for 2 March 2026, a date it confirmed in December 2025 was unchanged, saying the data connection and refresh capabilities would stop working while the Excel table data remained intact. See /guides/how-to-use-visio-data-visualizer for the current status.

Can I refresh a data-connected Visio diagram in the browser?

No. Microsoft lists diagrams connected to Excel, Access, SharePoint lists, SQL Server and other OLEDB or ODBC sources among those that cannot be edited in Visio for the web, and states that data linking is available only through the Visio desktop app, although the browser can view data-linked diagrams and read values through Shape Info. Since Visio Plan 1 is web and Teams only, the practical requirement for refreshing from Excel is a Windows machine running the desktop app on Visio Plan 2, which is US$15.00 per user per month paid yearly at list price at the time of writing. There is no Visio desktop app for macOS.