Why Visio Organization Charts Do Not Reposition Employees After an Excel Refresh
Question details
The user needs an organization chart to reflect changed reporting relationships in a linked Excel file.

- 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.
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.
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.
Open the Excel workbook, edit the supervisor or reports-to column for affected employees, and save the file.
In Visio, select File > New, search for Organization Chart, and create a chart using the Organization Chart Wizard.
In the wizard, choose information already stored in a file or database, select the Excel file, and browse to the updated workbook.
Follow the wizard prompts to identify the employee name and reports-to fields, select any additional fields to display, and finish the import.
Review the generated chart and confirm that affected employees appear under their current supervisors. Adjust the layout or formatting in Visio as needed.

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.

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.




