Fix Visio Create Diagram from Data Fails with Internal Error -1
Question details
The user encounters an Internal Error -1 in Visio when trying to use the Create from Data wizard with a large or complex Excel table.

- Product
- Microsoft Visio, Microsoft Excel
- Device & OS
- not provided
- Scenario
- Importing a complex Excel table with numerous rows or intricate connector structures into Visio to auto-generate a flowchart.
- Observed behavior
- The data import wizard fails and displays Internal Error -1, or returns a blank workbook. The diagram only generates if the row count is reduced significantly.
Ensure your Excel workbook is saved and fully closed before importing, as open files can cause read conflicts during the Visio import process.
Perform an Online Repair of Microsoft Visio
Use this solution to fix underlying corruption in the Visio installation that might be preventing data from importing correctly.
The 'Internal Error -1' often stems from corrupted Visio installation files or registry keys. Performing an Online Repair resets the application to its default state without affecting your saved diagram files.
Press the Windows key, type 'Control Panel', and press Enter. Navigate to 'Programs' and select 'Uninstall a program'.
Scroll through the list of installed programs to find Microsoft Visio. Right-click on it and select 'Change'.
In the dialog box that appears, choose 'Online Repair' (not Quick Repair) and click 'Repair'. Follow the on-screen prompts to complete the process.

Use the Basic Flowchart Data Visualizer Template
Bypassing the standard wizard and using the built-in Data Visualizer template directly from the 'New' menu can circumvent certain import bugs.
Disable Macros and Application Add-ins
Third-party add-ins or automated macros can interfere with Visio's data import engine. Disabling them helps isolate the conflict.
Discover a Lightweight Alternative with WPS Office
If you are experiencing frequent errors with Microsoft Office tools like Visio and Excel, consider switching to WPS Office. It provides powerful tools for spreadsheets, documents, presentations, and drawing with high compatibility and a familiar interface.
- 1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet to open your .xlsx data files effortlessly and without compatibility issues.
- 3. Create Diagrams: Use the robust Insert > Shapes features in WPS Presentation or WPS Writer to manually build and customize your flowcharts.

Frequently Asked Questions
Is there a maximum row limit for the Visio Data Visualizer?
Visio does not have a strict hardcoded row limit, but complex connectors and highly dense data structures can cause the engine to fail or timeout. Reducing the data to under 400 rows often helps isolate whether the issue is data volume or complexity.
Why does the Create from Data wizard result in a blank workbook?
This usually happens if the Excel file is locked, contains invalid relationships between shapes, or if Visio's automation events are blocked by conflicting third-party add-ins.
Can macros in my Excel file cause Visio import errors?
Yes, active macros or VBA scripts can interfere with Visio's ability to read the data structure. Disabling macros temporarily in the Trust Center can resolve the conflict and allow the import to proceed.




