Others

How to Fix Visio Organization Chart Not Refreshing from Excel Data

Camila MilosovichCamila Milosovich Nov 3, 2026 870 views

Question details

The user needs to know how to resolve an issue where a Visio Professional 2019 organization chart does not update when changes are made to the linked Excel source data.

How to Fix Visio Organization Chart Not Refreshing from Excel Data
Product
Microsoft Visio Professional 2019 / Microsoft Excel
Device & OS
not provided
Scenario
Updating a Visio organization chart that is linked to an external Excel data file.
Observed behavior
Changes made to the manually entered raw data in the Excel file do not reflect or refresh in the connected Visio organization chart.
Before you start

Ensure that your Excel source file is completely closed before attempting to refresh the data in Visio, as open files can sometimes create a lock that blocks data synchronization. Additionally, confirm that the Excel file has not been renamed or moved to a different folder.

Solution 1Recommended

Verify Data Connection and Source File Path

Check if the link between Visio and the Excel file is broken due to renamed files or changed directory paths.

When an Excel file is moved, renamed, or replaced, Visio loses the path to the original raw data, preventing the organization chart from refreshing. Re-establishing this connection is the most common fix.

1
Open External Data Window

In your Visio Professional 2019 organization chart, navigate to the 'Data' tab on the top ribbon and click on 'External Data Window' to view the current connected sources.

2
Check Data Source Settings

Right-click the data source in the External Data Window and select 'Data Source Settings'. Verify that the file path points to the exact, current location of your Excel file.

3
Re-link if Necessary

If the file path is incorrect, you must re-link it by selecting 'Link Data to Shapes' from the Data tab and browsing your computer to choose the updated Excel workbook.

Verify Data Connection and Source File Path
Check Excel File Format: Ensure your Excel data file is saved in a standard format like .xlsx. Using older .xls formats or heavily macro-enabled workbooks can sometimes disrupt data connectivity.
Free Microsoft Office alternative

Manage Data and Create Charts Seamlessly with WPS Office

While Visio is a dedicated diagramming tool, dealing with broken data links between Office applications can be frustrating. WPS Office provides a robust, lightweight, and completely free alternative for your daily office tasks, including powerful built-in diagramming and SmartArt features that make visualizing organizational data simple and hassle-free.

  1. 1. Download and Install WPS Office: Get WPS Office for free from the official website and install it on your device.
  2. 2. Open a Document or Presentation: Launch WPS Writer or WPS Presentation, which both feature built-in graphic tools.
  3. 3. Insert an Organizational Chart: Navigate to the 'Insert' tab, select 'SmartArt' or 'WPS Process', and choose a hierarchy or organization chart template. Type your data directly into the shapes for instant visual updates.
Fully compatible with Microsoft Excel (.xlsx) formats to manage your raw data easily.Lightweight and completely free to use, saving you expensive subscription costs.Built-in flowchart, mind-mapping, and SmartArt tools for easy organizational chart creation.Familiar, tabbed user interface ensures a zero-learning-curve transition from Microsoft Office.
microsoft office alternative - wps office

Frequently Asked Questions

Why is the 'Refresh Data' button grayed out in my Visio organization chart?

This typically occurs if the organization chart was not originally created using the Organization Chart Wizard linked to external data, or if the connection to the underlying Excel file has been permanently severed. You may need to run the Organization Chart Wizard again to properly establish the data link.

Can I link Visio to a shared Excel file stored on OneDrive or SharePoint?

Yes, you can link to cloud-stored Excel files. However, you must ensure that the file path used in Visio points to your local sync folder or the direct SharePoint URL. If the Excel file is actively being edited online by another user, Visio may be unable to lock the file to perform a data refresh.

What happens if I add new rows in Excel instead of just updating existing data?

When you add entirely new rows (new employees) to the Excel source data, simply clicking 'Refresh All' in the Data tab might not automatically draw new shapes. You often need to go to the 'Org Chart' tab, click 'Update', and let the wizard evaluate the new data structure to generate the new hierarchy shapes.