How to Dynamically Link a Named Excel Range or Table to Visio
Question details
The user wants to link Excel data to a Visio diagram using a dynamic named range or table instead of a static cell reference.

- Product
- Excel, Visio
- Device & OS
- not provided
- Scenario
- Linking an external Excel dataset to a Visio diagram so that the linked data automatically expands when new rows or columns are added.
- Observed behavior
- Using standard static R1C1 references prevents the linked range from resizing, causing new data rows or columns to be excluded from the Visio diagram.
Ensure your Excel dataset is formatted as a Table or has a Defined Name assigned to the range. Also, make sure the Excel workbook is saved and fully closed before importing it into Visio.
Use a Custom Range or Table Name in Visio Data Selector
Connect Visio to your Excel file and manually specify the Excel Table name to ensure dynamic updates.
When you link an Excel worksheet to Visio using standard settings, Visio often applies a static range (such as R1C1:R20C5). By utilizing Excel Tables and specifying them as a custom range, you can ensure Visio captures newly added rows and columns upon data refresh.
Open your Excel workbook, select your dataset, and press Ctrl+T to format it as a Table. Take note of the Table Name (e.g., Table1) found in the Table Design tab. Save and close the file.
In Visio, go to the Data tab, click 'Custom Import' (or 'Link Data to Shapes' in older versions), and select 'Microsoft Excel workbook' as your data source.
Click Browse, locate your saved Excel .xlsx file, and click Next.
Instead of selecting a specific worksheet with default static ranges, look for the 'Custom Range' option or type your exact Table name (e.g., Table1) into the range field provided.
Proceed through the rest of the wizard to link your data rows to Visio shapes. The data will now dynamically resize when refreshed.

Define a Dynamic Named Range Using the OFFSET Formula
If standard table formats are not supported by your specific Visio workflow, create a dynamic formula-based Named Range in Excel.
Create Dynamic Data Tables with WPS Spreadsheet
WPS Spreadsheet allows you to easily format standard .xlsx files with defined names and dynamic tables, ensuring seamless integration and data updating with external diagramming tools like Visio.
- 1. Open your dataset: Launch WPS Spreadsheet and open the workbook containing the data you want to link to Visio.
- 2. Format as Table: Select your entire data range, navigate to the Home tab, and click 'Format as Table' to make the range dynamic.
- 3. Define a Custom Name: Alternatively, select the data, go to the Formulas tab, click 'Name Manager', and define a custom name for your data range.
- 4. Save and Close: Save your file in the standard .xlsx format and close the application before importing the data into your diagramming software.

Frequently Asked Questions
Why doesn't my Visio diagram show new Excel rows when I refresh?
If your data link uses a static cell reference (like R1C1 or A1:D10) chosen during the initial import, it won't include new rows outside that boundary. You must link to a formatted Table or a dynamic Named Range for it to expand automatically.
How do I name a range in Excel or WPS Spreadsheet?
Select the cells you want to name, click the Name Box located to the left of the formula bar, type a unique name without spaces, and press Enter.
Does Visio support linking directly to standard Excel Tables?
Yes, modern versions of Visio's Data Selector allow you to specify the exact name of an Excel Table (e.g., Table1) in the custom range field, which inherently supports dynamic resizing.
Can I use WPS Office to create the linked data file for Visio?
Absolutely. WPS Spreadsheet natively saves files in the standard .xlsx format, which is fully compatible with external diagramming tools that import spreadsheet data via OLE or ODBC.




