How to update a Visio flowchart from Excel
Visio has two different Excel-refresh mechanisms with different ribbon tabs and opposite sync directions. Which one your diagram uses decides whether changes can travel back to the workbook — and whether your formulas survive.
A worked example, stage by stage
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.
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.
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.
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
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.
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.
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.
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.
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.
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.
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.