Others

How to Refresh an Embedded Excel-Linked Visio Data Visualizer Diagram

Chanuka Geekiyanage Oct 15, 2026 869 views

Question details

The user wants to know if an embedded Visio Data Visualizer diagram maintains its link to an Excel table and how to manually refresh the diagram when the underlying Excel data is modified.

Product: Microsoft Excel, Microsoft Visio
Device & OS: not provided
Scenario: Updating source data in an Excel workbook that is actively linked to an embedded Visio Data Visualizer flowchart.
Observed behavior: The embedded Visio object requires a manual refresh action to properly reflect the newly saved data in the Excel table.

Before you start

Ensure you have fully saved the recent changes made to your source Excel workbook before attempting to update the embedded Visio flowchart.

Solution 1Recommended

Refresh the Embedded Visio Diagram via the Data Design Tab

Access the embedded Visio object directly within Excel to trigger a data refresh and update the flowchart.

Once your Excel data is updated, the linked Visio diagram does not automatically change in real-time. You must manually prompt the diagram to fetch the newest data from your spreadsheet.

Save the Excel Data

Modify the necessary flowchart data within your Excel table and save the workbook.

Activate the Embedded Object

Double-click the embedded Microsoft Visio Diagram object located within your Excel spreadsheet to open the Visio editing interface.

Select the Flowchart Container

Click directly on the outer container of the flowchart to select the entire visualizer diagram.

Refresh the Diagram

Navigate to the Data Design tab in the ribbon and click on 'Refresh Diagram'. The flowchart will now update to match the saved Excel data.

Refresh the Embedded Visio Diagram via the Data Design Tab

License Requirements: The Visio Data Visualizer desktop feature requires a Visio Plan 2 subscription. This is different from the basic Data Visualizer Excel add-in, which is available to certain Microsoft 365 accounts without an extra license.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet and Diagram Management

If you are looking for an accessible way to manage data and create robust diagrams without an expensive Visio subscription, WPS Office provides a free, lightweight alternative that handles your spreadsheet needs effortlessly.

1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your computer.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx files seamlessly.
3. Insert Flowcharts and Shapes: Navigate to the Insert tab to easily add shapes, smart graphics, or process flowcharts directly into your workbook.

Highly compatible with Microsoft Excel (.xlsx) formatsInsert built-in flowcharts and shapes directly into your spreadsheets without extra add-insFree to use with a familiar, easy-to-navigate interfaceCross-platform support across Windows, Mac, and mobile devices

microsoft office alternative - wps office

Frequently Asked Questions

Do I need a special license to use the Visio Data Visualizer in Excel?

Using the embedded Visio Data Visualizer desktop feature typically requires a Visio Plan 2 subscription. However, the basic Data Visualizer Excel add-in is available in Excel for certain Microsoft 365 work or school accounts without needing a separate Visio license.

Why doesn't my embedded Visio flowchart update automatically?

Embedded Visio diagrams do not sync in real time to prevent performance issues. You must save your Excel data changes, double-click the Visio object to activate it, and click 'Refresh Diagram' on the Data Design tab.

How do I initially insert the Visio Data Visualizer in Excel?

In Excel, go to Insert > Text > Object, select Microsoft Visio Diagram, and choose Basic Flowchart - Data Visualizer. During the Visio wizard setup, select your open Excel workbook as the data source.

Office Quick Solutions