Data Import & Export

Fix Visio Error 1981 When Adding Shape Data Columns from Excel

Maira Mehtab Sep 20, 2026 869 views

Question details

Users encounter Error 1981 when attempting to add shape-data groups or synchronize structural changes between a Visio cross-functional flowchart and its linked Excel datasheet.

Product: Microsoft Visio and Excel
Device & OS: not provided
Scenario: Synchronizing shape data and adding new columns to a Data Visualizer flowchart in Visio that is linked to an external Excel file.
Observed behavior: The application returns Error 1981 when the user tries to update source data or add shape-data groups directly within the Visio interface.

Before you start

Ensure that your linked Excel file is closed or not locked by another user in read-only mode. It is highly recommended to save a backup copy of both your Visio diagram and Excel datasheet before modifying the table structures.

Solution 1Recommended

Add Columns Directly in Excel First

The most reliable method to prevent sync errors is to add new data columns inside the linked Excel table instead of adding them directly to the Visio shapes.

Adding a field directly to Visio shapes and attempting to push it using 'Update Source Data' frequently fails to update the Excel file, resulting in Error 1981. Driving the structural changes from Excel ensures the data source remains the master record.

Open the Linked Excel File

Locate and open the Excel datasheet that is actively linked to your Visio Data Visualizer diagram.

Insert a New Column into the Table

Add your new column directly inside the existing Excel table boundaries. Ensure it is formatted as part of the table, not merely placed in an adjacent, unformatted cell.

Save the Excel File

Save your changes and close the Excel application if necessary to release any file locks.

Refresh Diagram in Visio

Return to your Visio flowchart, navigate to the 'Data' tab, and select 'Refresh Diagram'. The new fields will now automatically populate into every flowchart shape.

Table Boundaries Matter: If the new column is adjacent to the Excel table but not officially included in the table's range, Visio will not recognize the new field.

Solution 2

Rebuild Files with Pre-allocated Filler Columns

If the file synchronization is permanently broken and Error 1981 persists, rebuilding the files with extra placeholder columns can serve as a robust long-term workaround.

Free Microsoft Office alternative

Try WPS Office for Seamless Data Management and Smart Diagrams

Tired of complicated file synchronization errors between different applications? WPS Office offers a unified suite where you can easily handle spreadsheets, documents, and presentations with high compatibility. Use intuitive, built-in smart shapes and charting tools to organize your data effortlessly without dealing with third-party linkage crashes.

1. Download and Install WPS Office: Visit the official WPS Office website and download the free lightweight installer for your operating system.
2. Open WPS Spreadsheet: Launch the suite and open WPS Spreadsheet to create or edit your .xlsx data files with complete format compatibility.
3. Utilize Built-in Shapes: Go to the 'Insert' tab and use the 'Shapes' menu to build direct visual representations and flowcharts alongside your data.

Highly compatible with Microsoft Excel (.xlsx) formats and formulasUnified tabbed interface eliminates complex cross-application sync errorsBuilt-in flowchart and diagramming capabilities in WPS Presentation and WriterLightweight, fast to launch, and consumes minimal system resources

Frequently Asked Questions

Why do I get Error 1981 when updating Visio shape data?

Error 1981 typically occurs when Visio attempts to write structural changes (like new shape-data fields) back to a linked Excel file and fails. This frequently happens if the field is added directly in Visio instead of updating the source Excel table.

Can I add new fields directly to Visio shapes and push them to Excel?

Generally, no. Adding a field to a Visio shape and clicking 'Update Source Data' often fails to add the column in Excel. The recommended practice is to add the column in the Excel file first, then use 'Refresh Diagram' in Visio.

Why doesn't my new Excel column show up in Visio after refreshing?

The new column must be recognized as an integrated part of the formatted Excel Table. If you type data into a cell adjacent to the table without expanding the table's boundaries, Visio's Data Visualizer will not detect the new column.

How can I prevent this synchronization error in the future?

To minimize data sync errors, drive all structural changes from Excel. Additionally, you can create extra 'filler' columns in your initial Excel table. When you need a new field, rename a filler column instead of restructuring the table entirely.

Excel & Data Problems