Others

Fix Visio Create Diagram from Data Fails with Internal Error -1

Camila MilosovichCamila Milosovich Nov 2, 2026 868 views

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.

How to Fix Visio Internal Error -1 When Creating Diagrams from Excel Data
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.
Before you start

Ensure your Excel workbook is saved and fully closed before importing, as open files can cause read conflicts during the Visio import process.

Solution 1Recommended

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.

1
Open Control Panel

Press the Windows key, type 'Control Panel', and press Enter. Navigate to 'Programs' and select 'Uninstall a program'.

2
Modify Visio Installation

Scroll through the list of installed programs to find Microsoft Visio. Right-click on it and select 'Change'.

3
Run Online Repair

In the dialog box that appears, choose 'Online Repair' (not Quick Repair) and click 'Repair'. Follow the on-screen prompts to complete the process.

Perform an Online Repair of Microsoft Visio
Online Repair Duration: The Online Repair process requires an active internet connection and may take several minutes to download and reinstall necessary components.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your device.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheet to open your .xlsx data files effortlessly and without compatibility issues.
  3. 3. Create Diagrams: Use the robust Insert > Shapes features in WPS Presentation or WPS Writer to manually build and customize your flowcharts.
Fully compatible with Microsoft Excel (.xlsx) formats to manage your complex data.Built-in flowchart and drawing tools serve as a lightweight alternative for diagramming.Free to download and uses significantly fewer system resources than traditional office suites.Seamless migration with a highly familiar user interface.
microsoft office alternative - wps office

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.