How to Fix Visio Organization Chart Not Refreshing from Excel Data
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.

- 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.
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.
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.
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.
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.
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.

Force Manual Refresh and Check Data Mapping
Ensure Visio is configured to refresh data and that the columns in Excel correctly map to the shapes in the chart.
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. Download and Install WPS Office: Get WPS Office for free from the official website and install it on your device.
- 2. Open a Document or Presentation: Launch WPS Writer or WPS Presentation, which both feature built-in graphic tools.
- 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.

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.




