If your Visio org chart is linked to an Excel workbook, open the diagram in Visio for Windows and choose Data > Refresh All to pull in saved changes to linked data. If you created the chart by importing a spreadsheet with the Organization Chart Wizard, it may not have a live data connection; in that case, refreshing Excel alone will not update the chart, and you may need to import the data again or edit the diagram.
What refreshing a Visio org chart actually does
Visio can connect diagram shapes to rows in an external data source, including an Excel workbook. A refresh checks that source and updates the data associated with shapes that are already linked. Depending on how the diagram is set up, the refreshed values may also affect data graphics or other visual cues that display those values.
That is different from rebuilding the org chart. Refreshing linked data does not necessarily create a new employee shape, remove a departing employee, move a person to a new manager, or rearrange the reporting hierarchy. Think of refresh as updating the information behind existing links, not as an instruction to redesign the diagram from the current spreadsheet.
There are two common starting points, and the distinction matters:
- Imported chart: The Organization Chart Wizard reads spreadsheet information to make a diagram. Unless the diagram also has an external data link, later edits in Excel are not automatically synchronized.
- Data-linked diagram: Visio has a connection to the workbook and links source rows to shapes. Use Data > Refresh All to retrieve changes to linked records.
If you are unsure which kind you have, look for the External Data window or other visible evidence of linked rows in Visio. A chart that merely looks like it came from Excel is not necessarily connected to the workbook.
Refresh a linked chart in Visio for Windows
Use the following sequence when the diagram already has an Excel data connection. Menu labels can vary slightly with Visio edition and interface updates, but the refresh command is on the Data tab in Visio desktop.
- Save the Excel workbook after making your edits. Visio cannot retrieve changes that have not been saved to the source file.
- Open the Visio diagram and confirm that it is using the workbook you changed. If the workbook was moved or renamed, the saved connection may point to the old location.
- In Visio, select Data > Refresh All. If Visio asks about the source or access, follow the prompt and select the correct workbook.
- Review the diagram and any external-data rows. Check that the employee fields you changed now show the expected values.
- Save the Visio file after checking the result. The refresh changes the diagram document, so saving preserves the updated state.
For a single linked record, some Visio versions and diagram setups let you refresh selected data rather than every connection. If you do not see a selected-item refresh option, use Refresh All and verify the result. Refreshing all sources is usually straightforward, but it can also update other linked data in the same drawing.
Visio for the web is useful for viewing and editing many diagrams, but the desktop Windows application is the practical choice when you need to manage an Excel data connection or diagnose a refresh. Availability depends on your Visio plan and the features supported by the file.
If you used the Organization Chart Wizard
The Organization Chart Wizard is designed to build a hierarchy from employee information, such as a name and a reports-to field. It helps map spreadsheet columns to chart information and create the initial set of shapes. That import should not be confused with a continuing, two-way link between the Excel workbook and every shape in the finished chart.
To check your situation, open the diagram in Visio and inspect the Data tab and any external-data display. If there is no workbook connection or linked-row information, pressing Data > Refresh All cannot fetch new spreadsheet values. The chart may contain information copied during the import, but copied data is not the same as a live connection.
For a small change, edit the relevant shape or its shape data in Visio. For a larger update, correct the source workbook and run the chart-creation process again, then review the generated diagram before replacing the old one. Keep a copy of the existing file: recreating a chart can affect manual layout choices, formatting, callouts, and other custom work.
If you need regular updates, consider creating a data-linked diagram rather than relying on a one-time import. Visio’s data-linking tools and the Organization Chart Wizard serve related but distinct purposes: one connects rows to shapes, while the other helps generate an organizational hierarchy.
Prepare the Excel workbook before refreshing
A dependable refresh starts with a predictable source. Keep the workbook in a stable location, preserve the worksheet and column structure used by Visio, and save it before refreshing. Renaming a workbook, moving it to a different folder, or changing the relevant sheet can break a connection or cause Visio to request that you locate the source again.
Use one row per employee and clear, consistent column headings. For a hierarchy, the data normally needs a way to identify each person and a way to identify that person’s manager, such as a unique employee identifier and a manager identifier. Names alone can be ambiguous when two people share a name. Avoid blank or duplicate identifiers in fields used to match records.
- Do not casually rename or delete columns that Visio mapped to shape data.
- Keep employee identifiers consistent, including any leading zeros that are meaningful.
- Check that manager references point to the intended employee and that the top-level leader is represented correctly.
- Save formula-driven changes in Excel and confirm their displayed results before refreshing Visio.
These practices reduce matching errors, but they do not make a static import live. The workbook still needs to be connected to the diagram for Visio’s refresh command to retrieve its data.
Why a new hire or reporting change may not appear
A frequent misunderstanding is that adding a row in Excel and selecting Refresh All will automatically add a new box to an org chart. In a typical data-linked diagram, refreshing updates linked data; it does not automatically construct and position a new organizational shape for every newly added row. The same limitation applies to a changed manager relationship: updated source data does not guarantee that the chart’s connectors and layout will be rebuilt.
For a new employee, check whether the new row is visible in Visio’s refreshed external data. If it is, the source connection may be working even though the chart has no new shape. You may need to create a shape and link it to that row, or regenerate the org chart from the updated source. If the row is not visible at all, investigate the selected worksheet or range, connection path, and whether the workbook was saved.
For a manager change, distinguish the employee’s displayed manager information from the actual connector structure. A text field can update while the diagram still shows the old reporting line. Correct the hierarchy in the source and then rebuild or manually adjust the affected chart structure, as appropriate for how the diagram was made.
Troubleshoot refresh problems
If Refresh All runs but the values remain unchanged, work through the likely causes rather than repeatedly clicking the command.
- Unsaved Excel edits: Save the source workbook, close or save any pending edits, and refresh again.
- Wrong workbook or location: Confirm the connection points to the file you edited. If the file moved, browse to its current location when prompted or repair the connection using the available data-link options.
- Changed worksheet or columns: Restore the expected sheet and headings, or update the connection and mappings. A renamed field may no longer correspond to the shape data Visio expects.
- Unmatched records: Check identifiers and key values for extra spaces, duplicates, changed formats, or missing entries. A row that cannot be matched may not update the intended shape.
- Static diagram: If no external data link exists, there is nothing for Refresh All to query. Re-import the data or create a linked diagram.
- Connection access: Confirm that you can open the workbook and that its location is available to your account. Network, cloud, or permission changes can prevent Visio from reaching the source.
Before changing a working source layout or rebuilding a complex chart, save a separate copy of the Visio file. That gives you a way back if a repair or re-import changes the layout unexpectedly.
Choosing between a data link and a re-import
The best approach depends on what changes most often. A data-linked diagram is useful when employee attributes such as department, title, location, or contact details change while the chart’s shape structure remains mostly stable. It reduces repetitive manual updates to displayed values, provided the connection and row matching are maintained.
A fresh import or chart rebuild may be more suitable when the reporting structure changes frequently or when many employees join, leave, or move between managers. It can generate a hierarchy from the updated source, but you should plan to review page breaks, layout, and custom formatting afterward. For a tiny team, manually adjusting a few shapes may be quicker; for a large organization, repeatable, well-maintained source data is more important.
Visio editions and licenses differ in which data-linking features they include. If you cannot find the data-linking commands, check the capabilities of your Visio edition rather than assuming the workbook itself is defective. Also distinguish Visio desktop features from Excel-based add-ins or templates: the fact that a chart was initiated from Excel does not by itself establish a live Visio connection.
Frequently Asked Questions
Can Visio automatically update an org chart when Excel changes?
Only if the diagram has an appropriate data connection, and even then refresh is not necessarily automatic. In Visio desktop, use Data > Refresh All to retrieve saved source changes. New shapes and hierarchy changes may still require manual work or a chart rebuild.
Why is Data > Refresh All not updating my Visio chart?
The diagram may be a one-time import rather than a linked diagram, or Visio may be pointing to a different workbook. Save Excel, verify the file and sheet used by the connection, and check whether linked rows are present in Visio.
Will refreshing add a new employee to the org chart?
Not necessarily. A refresh can bring a new source row into the linked data, but it generally does not create and place the employee’s shape or connect that shape to a manager automatically.
Can I refresh a Visio org chart from Excel on a Mac?
Visio’s full desktop diagram and data-linking workflow is centered on Visio for Windows. Excel for Mac can edit and save the workbook, but it is not a replacement for the Visio desktop refresh command. Use a supported Visio environment to refresh the diagram.
Does refreshing Visio update the Excel workbook too?
No. The usual data-link refresh reads source information into the Visio drawing; it is not a two-way synchronization process that writes diagram edits back to Excel. Make authoritative employee-data changes in the workbook or the system that owns the data.
Related
- Randomize Names in Excel Without Repeats: Easy Methods
- Randomize Groups in Excel: A Practical Guide
- Randomize in Excel Without Repeating Numbers: 3 Ways
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table Options: Settings, Layouts, and AnalysisExcel PivotTable options let you control how a summary is arranged, calculated, filtered, refreshed, and displayed. In Microsoft…
- Excel Chart Dates Not Matching Data? Fix the AxisIf Excel chart dates do not line up with the source data, first check whether the date cells…
- Google Sheets Chart Aggregate: How to Group Chart DataYes. In Google Sheets, a chart’s Aggregate option can combine rows that share the same value on the…
- Dynamic Dashboard in Excel: Build One That UpdatesA dynamic dashboard in Excel is a visual summary that updates when its underlying data changes or when…
- Add Power Pivot to Excel: Enable It and Get StartedTo add Power Pivot in Excel for Microsoft 365 on Windows, select File > Options > Add-ins, choose…
- Excel Column Chart With Two Data Sources: How to Build OneYes. In Excel for Microsoft 365, you can put two data sources in one column chart by adding…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.