Others

Fix Visio Organization Chart Not Refreshing Reporting Relationships

Olivia Miller Sep 27, 2026 868 views

Question details

Users need to update the hierarchy of an existing Visio organization chart linked to an Excel file, as data refreshes only update individual shape information.

How to Fix Visio Organization Chart Not Refreshing Reporting Relationships

Product: Microsoft Visio
Device & OS: not provided
Scenario: Updating reporting relationships and organizational hierarchy based on a modified, linked Excel data source.
Observed behavior: Using the data refresh option successfully updates individual employee details (like names or titles) but does not move shapes or alter the reporting relationships built during the initial chart creation.

Before you start

Ensure that your source Excel file contains an accurate and fully updated 'Reports To' or equivalent supervisor column before attempting to rebuild your organizational hierarchy.

Solution 1Recommended

Rerun the Organization Chart Wizard

Since Visio does not retain a live structural link after generating the initial diagram, rerunning the wizard is the most reliable way to bulk-update reporting relationships.

The built-in Organization Chart Wizard is designed to map out hierarchy only during the initial creation phase. When you use Data > Refresh All, Visio exclusively updates the properties of the existing shapes rather than reconstructing the chart's layout.

To reflect structural changes such as employee promotions or departmental shifts, you must run the wizard again using your updated data file.

Launch the Wizard

Open Microsoft Visio, click on File, select New, and choose Organization Chart. Click on the Organization Chart Wizard to begin.

Select Source Data

Choose the option to create your chart from information that is already stored in a file or database, and click Next.

Import Updated Excel File

Locate and select the updated Excel spreadsheet that contains your new reporting relationships, then map the 'Name' and 'Reports To' columns correctly.

Generate the Chart

Complete the remaining wizard prompts to generate a brand new layout that accurately reflects your updated organizational hierarchy.

Manual Adjustments: For minor reporting relationship changes, you do not need to rerun the wizard. You can manually drag a subordinate shape and drop it directly onto their new manager's shape within the Visio canvas.

Solution 2

Use the Visio Data Visualizer Add-in for Excel

Switching to the Visio Data Visualizer add-in within Microsoft Excel provides a more dynamic, two-way syncing experience for updating both shape data and hierarchy.

Free Microsoft Office alternative

Create Flexible Organization Charts with WPS Office

If you are tired of complex data-linking issues and expensive Visio licenses, WPS Office offers an incredibly intuitive way to build organization charts. Using the robust SmartArt tools in WPS Spreadsheet or Presentation, you can easily map out hierarchies without the hassle of failed data refreshes.

1. Download and Install WPS Office: Visit the official WPS website to download the free suite and install it on your device.
2. Open a Spreadsheet or Presentation: Launch WPS Office and open a new document where you want to build your organization chart.
3. Insert SmartArt Hierarchy: Go to the Insert tab, click on SmartArt, select Hierarchy, and easily add your team members and reporting lines.

Completely free, lightweight, and fast-performing Office suiteBuilt-in SmartArt and hierarchy diagram tools that are easy to update manuallySeamless format compatibility with Microsoft Excel (.xlsx) and PowerPoint (.pptx)Familiar user interface ensuring zero learning curve for new users

microsoft office alternative - wps office

Frequently Asked Questions

Why does Data Refresh All only update names and not reporting lines?

Visio's Organization Chart Wizard maps the hierarchical structure statically during the initial chart creation. The 'Data > Refresh All' command is specifically designed to update shape data fields (like Name, Title, or Department) but lacks the capability to rebuild the structural connections between the shapes.

Can I manually change reporting relationships in an existing Visio chart?

Yes. If you only have a few changes to make, you can manually drag a subordinate shape and drop it onto a new manager shape. Visio will automatically re-route the connector to reflect the new reporting relationship.

Do I need a Visio subscription to use the Visio Data Visualizer add-in in Excel?

The core functionality of the Visio Data Visualizer add-in is available to Microsoft 365 subscribers for creating, viewing, and basic editing of organization charts directly within Excel. However, advanced editing features require a premium Visio Plan subscription.

Office Quick Solutions