SharePoint Document Issues

How to Link a Visio Flowchart to an Excel File on SharePoint Online

Huma Ashraf ChHuma Ashraf Ch Oct 16, 2026 871 views

Question details

The user needs to connect a Visio flowchart directly to an Excel file hosted on SharePoint Online without relying on a personal OneDrive sync connection.

How to Link a Visio Flowchart to an Excel File on SharePoint Online
Product
Microsoft Visio, Excel, SharePoint Online
Device & OS
not provided
Scenario
Attempting to use Relink Source Data or Quick Import in Visio to fetch data from an Excel workbook stored on a SharePoint Online site library.
Observed behavior
Visio fails to establish a direct connection, returning an error message stating 'The selected file is not an Excel file or is currently unavailable.'
Before you start

Ensure you have the latest version of the OneDrive sync client installed on your computer and verify your permissions to view and edit files in the target SharePoint Online document library.

Solution 1Recommended

Use OneDrive Sync Client to Connect SharePoint Excel Data

Since direct web URLs to SharePoint are not fully supported by Visio's data connector, syncing the library locally bypasses the availability error.

Visio currently struggles to natively authenticate and parse direct SharePoint Online URLs for external Excel data sources. By syncing the SharePoint document library to your local machine using the OneDrive client, you create a local file path that Visio can read successfully while still maintaining live synchronization with the cloud.

1
Sync the SharePoint Library

Navigate to your SharePoint Online document library in a web browser and click the 'Sync' button located in the top toolbar. Allow the OneDrive client to map the folder locally.

2
Open Visio from the Synced Folder

Open Windows File Explorer, navigate to the newly created local SharePoint sync folder, and double-click to open your blank or existing Visio drawing.

3
Import Excel Data

In Visio, go to the 'Data' tab on the ribbon and select 'Quick Import' (or 'Custom Import').

4
Link the Local File

Browse your computer for the synced local folder, select the corresponding Excel file, and complete the import wizard.

5
Generate the Flowchart

Select 'Create' > 'Basic Flowchart' to generate your diagram from the imported Excel table data. The connection will remain active and sync with SharePoint.

Use OneDrive Sync Client to Connect SharePoint Excel Data
Keep OneDrive Running: As long as the OneDrive sync client is running in the background, any online changes to the Excel file will sync locally, keeping your Visio flowchart data accurate.
Free Microsoft Office alternative

Create Professional Spreadsheets and Diagrams with WPS Office

If you frequently encounter cross-app synchronization errors and linking issues, consider WPS Office. It provides an all-in-one suite for spreadsheets, documents, and diagramming without the complex sync limitations of traditional platforms.

  1. 1. Download and Install: Visit the official WPS Office website to download and install the free, lightweight suite on your device.
  2. 2. Organize Data in WPS Spreadsheet: Open WPS Spreadsheet to easily manage, edit, and format your data with full compatibility for existing Excel files.
  3. 3. Insert Built-in Flowcharts: Navigate to the 'Insert' tab to leverage native shapes, SmartArt, and built-in flowchart tools directly alongside your documents.
Fully compatible with Microsoft Excel (.xlsx) formatsBuilt-in robust flowchart and diagramming tools within the same applicationLightweight architecture ensuring fast loading and processingSeamless and integrated cloud synchronization without local file path errors
microsoft office alternative - wps office

Frequently Asked Questions

Why does Visio say my SharePoint Excel file is unavailable?

Visio lacks the native authentication protocols necessary to fetch raw table data directly from a SharePoint Online web URL, causing it to misread the file path or report format incompatibility.

Can I link Visio to Excel on SharePoint without syncing?

Currently, the most stable method requires using the OneDrive sync client. Direct web URL linking via SharePoint frequently results in availability or format errors due to application limitations.

Will my flowchart update automatically if the SharePoint Excel file changes?

Yes, provided the OneDrive client is actively syncing the SharePoint library to your computer. When the Excel file updates online, it pulls to your local drive, allowing Visio to refresh the data connection.

Are there other tools for combining spreadsheets and flowcharts?

Yes, comprehensive suites like WPS Office feature robust spreadsheet capabilities compatible with Microsoft Excel formats, alongside powerful built-in diagramming tools to help you create flowcharts seamlessly.