Resolve Visio Internal Error #-1 with Excel Data Graphics
Question details
The user needs to resolve an internal error in Microsoft Visio that occurs when applying data graphics linked to a shared Excel spreadsheet.

- Product
- Microsoft Visio, Microsoft Excel
- Device & OS
- not provided
- Scenario
- Applying data graphics to a Visio flowchart linked to an Excel table stored in another user's OneDrive or a shared folder.
- Observed behavior
- Visio displays 'Internal Error #-1' and fails to apply the data graphics to the flowchart.
Ensure you have full read and edit permissions for the shared Excel file and verify your current version of Microsoft Visio via File > Account before proceeding.
Work from a Local Copy of the Excel File
Moving the shared Excel workbook to a local drive prevents synchronization and permission conflicts that cause Visio to throw an internal error.
When Visio attempts to read an Excel file actively hosted in another user's OneDrive, background syncing or restricted network paths can interrupt the data connection.
Open the shared OneDrive folder in your browser or file explorer, right-click the target Excel workbook, and select 'Download' or 'Copy' to save it securely to a local folder on your computer's hard drive.
Open Microsoft Visio, create a new flowchart (or open your existing one), and navigate to the Data tab to link the graphics to your newly saved local Excel file instead of the shared path.
Select your flowchart shapes and apply the data graphics to confirm that the Internal Error #-1 no longer appears and the data populates correctly.

Isolate File-Specific Corruption
Test a completely different Excel file to determine if the issue is with Visio's settings or if the original spreadsheet is corrupted.
Try WPS Office for Stable Spreadsheet and Diagram Workflows
If you frequently encounter internal errors with Microsoft Office integrations and complex shared network files, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for managing Excel files, alongside robust built-in tools for creating standard flowcharts and diagrams without the hassle of synchronization errors.
- 1. Download and install: Get WPS Office from the official website and install it on your computer.
- 2. Open existing files: Open your Microsoft Excel (.xlsx) files seamlessly in WPS Spreadsheet to manage your data.
- 3. Create diagrams: Use the Insert > Shapes feature in WPS Writer or WPS Presentation to easily build standard flowcharts.

Frequently Asked Questions
Why does Visio show Internal Error #-1 specifically with OneDrive files?
This error typically occurs due to synchronization delays, permission conflicts, or complex path resolution issues when Visio attempts to read an Excel file actively hosted in another user's OneDrive or a heavily restricted shared network location.
Can I continue updating the shared Excel file in OneDrive after linking locally?
You can update the local file to keep your Visio diagram functioning. However, you will need to manually upload or replace the OneDrive version if you want collaborators to see your updated Excel data, as breaking the direct link stops real-time co-authoring.
How do I check my current Visio version to ensure it is up to date?
Open Microsoft Visio, click on 'File' in the top left corner, and select 'Account' (or 'Help' in older versions). Your specific version, build details, and update options will be displayed under the Product Information section.




