Others

Why Visio Organization Charts Do Not Reposition Employees After an Excel Refresh

Camila MilosovichCamila Milosovich Nov 14, 2026 869 views

Question details

The user needs an organization chart to reflect changed reporting relationships in a linked Excel file.

Why Visio Organization Charts Do Not Reposition Employees After an Excel Refresh
Product
Microsoft Visio and Microsoft Excel
Device & OS
not provided
Scenario
An organization chart was created from Excel data and linked to employee records. A supervisor is then changed in the Excel file.
Observed behavior
Refreshing updates the data in existing Visio shapes, but the employee shapes remain in their original reporting positions.
Before you start

Open the Excel source file and verify that each employee's supervisor is listed correctly in the reporting column. Save and close the file before importing it into Visio.

Solution 1Recommended

Recreate the Visio organization chart from the updated Excel file

Use the Organization Chart Wizard to build a chart that reflects the current reporting relationships in Excel.

Refreshing linked data updates information in existing shapes; it does not automatically add, remove, or reposition shapes when reporting relationships change. Re-layout alone does not rebuild the reporting hierarchy from the refreshed data.

1
Update the source data

Open the Excel workbook, edit the supervisor or reports-to column for affected employees, and save the file.

2
Start a new organization chart

In Visio, select File > New, search for Organization Chart, and create a chart using the Organization Chart Wizard.

3
Select the Excel source

In the wizard, choose information already stored in a file or database, select the Excel file, and browse to the updated workbook.

4
Map the reporting fields

Follow the wizard prompts to identify the employee name and reports-to fields, select any additional fields to display, and finish the import.

5
Check the new hierarchy

Review the generated chart and confirm that affected employees appear under their current supervisors. Adjust the layout or formatting in Visio as needed.

Recreate the Visio organization chart from the updated Excel file
A refresh is not a hierarchy rebuild: The new chart is generated from the current Excel data. Existing chart formatting or manual adjustments may need to be applied again.
Free Microsoft Office alternative

Maintain Organization Chart Source Data in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for editing Excel workbooks and moving between office tools. Use WPS Spreadsheets to maintain employee and supervisor data, then import the workbook into Visio to rebuild the chart; WPS does not change Visio's refresh behavior.

Edit employee and supervisor columns in a familiar spreadsheet interfaceWork with Microsoft Excel XLSX files for easier migrationUse a free, lightweight office suite for everyday document tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why does the supervisor field update without moving the employee shape?

Visio's linked-data refresh updates data in existing shapes, but it does not rebuild the chart hierarchy or move shapes to match a changed reports-to value.

Will using Visio's layout commands fix the reporting lines?

Layout commands arrange the existing chart; they do not create a new reporting hierarchy from refreshed Excel values. Reimport the updated workbook with the Organization Chart Wizard to rebuild it.

Does refreshing linked data add or remove employees from the chart?

No. Refreshing updates linked information in existing shapes; it does not automatically add or remove employee shapes. Recreate the chart from the updated Excel source to reflect those changes.

Which Excel columns are needed to rebuild the hierarchy?

Include an employee name column and a supervisor or reports-to column. In the Visio Organization Chart Wizard, identify these fields when prompted so the chart can use the reporting relationships.