Others

How to Refresh Excel Data and Preserve Visio Data Graphic Layouts

Steven ParkerSteven Parker Nov 13, 2026 868 views

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.

How to Refresh Excel Data and Preserve Visio Data Graphic Layouts
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel and add the Visio Data Visualizer add-in

In Microsoft Excel, click Insert > Get Add-ins or My Add-ins, search for "Visio Data Visualizer," and select Add.

2
Create a Data Visualizer workbook

In the Data Visualizer pane, choose a diagram category and template, then click Create to generate the linked Excel workbook and Visio diagram.

3
Replace sample data with your Excel data

Paste or enter your Excel columns and rows into the Data Visualizer table, including the fields you want to appear as Visio shape data.

4
Refresh the diagram

In the Data Visualizer pane, click Refresh or Save to update the Visio diagram with the new Excel columns and rows.

5
Check shape data and data graphics in Visio

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.

Use Visio Data Visualizer for Flexible Excel Data Mapping and Syncing
Best practice: Using Data Visualizer keeps the Excel data as the source of truth, which reduces layout changes when hidden shape data fields are restored or new data is added.
Free Microsoft Office alternative

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.

Free access to WPS Spreadsheets for editing Excel workbooks that feed data-driven processes.Native compatibility with Microsoft Excel formats including XLSX, XLS, and CSV.Familiar Office-style interface for a smooth transition from Microsoft Excel.Lightweight and fast for opening, editing, and preparing Excel data before use in other tools.
microsoft office alternative - wps office

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.