Fix Visio Error 1901 When Refreshing a Diagram from Excel
Question details
The user needs to resolve Visio Error 1901, which appears when refreshing a diagram linked to an Excel data source in Visio Plan 2 version 1908.

- Product
- Microsoft Visio Plan 2
- Device & OS
- Windows
- Scenario
- The user refreshes a Visio diagram connected to an Excel data source and needs the diagram to update without errors.
- Observed behavior
- Visio displays Error 1901: "Unable to update an action refresh diagram." The Excel data updates correctly, but the error appears in Visio Plan 2 version 1908.
Before troubleshooting, note the installed Visio/Office version and build, and confirm that the source Excel workbook still exists at the same location and has not been renamed.
Update Visio and Microsoft Office to the latest version
Use this first because Visio version 1908 is outdated and Office updates often include reliability fixes for diagram data refresh errors.
Visio version 1908 is an older Click-to-Run build. Updating to the latest build can resolve refresh errors without changing the diagram or its data link.
In Visio, click File > Account to see your product version and build information.
Under Product Information, click Update Options > Update Now. Allow the update to download and install, then restart Visio.
Reopen the diagram, go to the Data tab, click Refresh All, and check whether Error 1901 still appears.

Test the diagram with a different Excel workbook
Use this to rule out a moved, renamed, or corrupted Excel source file before deeper repair.
Repair Visio and isolate software conflicts
Use this if the error continues after updating Visio and testing a different Excel workbook.
Manage Excel Diagram Data in WPS Office as a Free Alternative
WPS Office is a free, lightweight Microsoft Office alternative that opens and edits Excel workbooks in .xlsx format, so you can maintain your diagram source data in a familiar interface without Visio refresh errors.
- 1. Download and install WPS Office: Go to the WPS Office download page, click Download WPS Office Free, and install the suite on your Windows PC.
- 2. Open the Excel data workbook: Launch WPS Spreadsheet, click Open, and select the Excel .xlsx workbook that you use as the Visio data source.
- 3. Review and save the source data: Check the data range, correct any issues, and save the workbook in .xlsx format before reconnecting it to your diagram application.

Frequently Asked Questions
Why does Visio show Error 1901 only when refreshing the diagram from Excel?
Visio version 1908 is an older build, and the error can also appear when the Excel source file has been moved, renamed, or corrupted. Check File > Account for the installed version and verify the Excel workbook path.
Should I update Visio before trying other fixes?
Yes. Open File > Account > Update Options > Update Now in Visio and install the latest Office updates first, because the 1908 build is outdated.
How do I test whether the Excel workbook is causing Error 1901?
Create a new Excel workbook with the same data structure, then in Visio use Data > External Data > Configure Refresh to link the diagram to the new file and run Refresh All.
How do I run Visio in Safe Mode?
Close Visio, then hold Ctrl while double-clicking the Visio shortcut, or press Windows + R, type visio /safe, and press Enter. Test the diagram refresh in Safe Mode.
Can WPS Office fix Visio Error 1901?
WPS Office does not repair Visio .vsdx diagrams, but it is a free alternative for editing the Excel data source. Use WPS Spreadsheet to open, clean, and save .xlsx workbooks.




