How to Link a Visio Flowchart to an Excel File on SharePoint Online
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.

- 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.'
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.
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.
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.
Open Windows File Explorer, navigate to the newly created local SharePoint sync folder, and double-click to open your blank or existing Visio drawing.
In Visio, go to the 'Data' tab on the ribbon and select 'Quick Import' (or 'Custom Import').
Browse your computer for the synced local folder, select the corresponding Excel file, and complete the import wizard.
Select 'Create' > 'Basic Flowchart' to generate your diagram from the imported Excel table data. The connection will remain active and sync with SharePoint.

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. Download and Install: Visit the official WPS Office website to download and install the free, lightweight suite on your device.
- 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. Insert Built-in Flowcharts: Navigate to the 'Insert' tab to leverage native shapes, SmartArt, and built-in flowchart tools directly alongside your documents.

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.




