How to Refresh Excel Data and Preserve Visio Data Graphic Layouts
Question details
The user needs to refresh Excel data that drives a Visio diagram without losing data graphic formatting, and to make newly added Excel columns or rows appear after the refresh.

- Product
- Microsoft Visio and Microsoft Excel
- Device & OS
- not provided
- Scenario
- Updating a Visio diagram linked to Excel data while preserving data graphic layouts and ensuring newly added Excel columns and rows are reflected.
- Observed behavior
- Visio data graphic fields can change appearance when hidden fields are restored, and newly added Excel columns or rows may not appear after a refresh.
Confirm that the diagram can be created or recreated with Visio Data Visualizer, and check that the Excel source table or data range includes the newly added columns and rows before refreshing.
Use Visio Data Visualizer for Flexible Excel Data Mapping and Syncing
Use this solution when you want a live Excel workbook to control the Visio diagram, so new Excel columns and rows appear in the diagram and data graphics remain stable.
Visio Data Visualizer creates a link between an Excel workbook and a Visio diagram. It maps Excel columns to Visio shape data, so new columns and rows are included after refresh and hidden shape data fields can be managed in one place.
In Microsoft Excel, click Insert > Get Add-ins or My Add-ins, search for "Visio Data Visualizer," and select Add.
In the Data Visualizer pane, choose a diagram category and template, then click Create to generate the linked Excel workbook and Visio diagram.
Paste or enter your Excel columns and rows into the Data Visualizer table, including the fields you want to appear as Visio shape data.
In the Data Visualizer pane, click Refresh or Save to update the Visio diagram with the new Excel columns and rows.
In Visio, open Data > Shape Data to review mapped fields, and use Data > Data Graphics to format the data graphic layout so restored hidden fields keep the intended appearance.

Refresh an Existing Data Visualizer Workbook and Restore Hidden Shape Data Fields
Use this solution when the diagram is already based on a Data Visualizer workbook and you only need to pull in newly added data and correct the data graphic layout.
Use WPS Office as a Free, Lightweight Alternative for Excel Workbooks
WPS Office does not create or edit Visio diagrams, but it provides a free, lightweight alternative for Excel and Word documents. It supports Microsoft Excel file formats, offers a familiar ribbon-style interface, and makes everyday spreadsheet work easy without a Microsoft 365 subscription.

Frequently Asked Questions
Why do newly added Excel columns or rows not appear after refreshing my Visio diagram?
New Excel columns or rows may not appear if they are outside the mapped table or data range that Visio is reading. In Visio Data Visualizer, make sure the new data is added inside the linked Excel table, then click Refresh in the Data Visualizer pane.
How does Visio Data Visualizer preserve data graphic layouts?
Data Visualizer maps Excel columns to Visio shape data and manages the data connection from the Excel workbook. When you refresh from the workbook, the data mapping is consistent, which reduces layout changes compared with manually hiding and restoring shape data fields.
Can WPS Office create or edit Visio diagrams?
No, WPS Office does not create or edit Visio diagrams. It can open and edit Excel workbooks, Word documents, presentations, and PDFs with strong Microsoft Office format compatibility.
Where can I add the Visio Data Visualizer add-in in Excel?
In Microsoft Excel, go to Insert > Get Add-ins or My Add-ins, search for "Visio Data Visualizer," and select Add. The add-in then appears in the Excel ribbon or task pane.
How do I map Excel columns to Visio shape data in Data Visualizer?
In the Data Visualizer workbook, use the provided column structure to enter your data. When you refresh or save, Data Visualizer maps the Excel columns to Visio shape data fields. You can then review them in Visio under Data > Shape Data.




