How to Use a Shared OneDrive or SharePoint Source for Power Pivot
Question details
Users need to configure Power Pivot to use a shared remote cloud path instead of a local file path so that all team members can refresh the data.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Collaborating on Power Pivot dashboards where multiple users need to refresh the shared data source.
- Observed behavior
- Data refresh fails for other users because the connection relies on a local synchronization path specific to the original author's Windows username.
Ensure you have an active Microsoft 365 account and that the source files have been successfully uploaded to a shared OneDrive or SharePoint location before configuring the connection.
Update Power Pivot Data Connection to a Remote URL
Change the data source path from a local synchronization folder to a direct OneDrive or SharePoint web URL to allow multi-user access.
When you select a file synced via the desktop OneDrive app, Power Pivot defaults to using the local C:\ path. To allow others to refresh the data, you must manually replace this local path with the remote SharePoint or OneDrive link.
Open File Explorer, navigate to your synced OneDrive or SharePoint folder, right-click the source file, and select 'OneDrive' > 'Copy Link' or 'Share'.
Paste the copied link into a text editor like Notepad. Remove any web parameters at the very end of the URL (such as '?web=1') to extract the raw file path.
Open your Excel workbook, go to the Power Pivot window, click on 'Design' in the top ribbon, select 'Existing Connections', choose your data source, and click 'Edit'.
Replace the local 'C:\Users\...' path with the cleaned SharePoint or OneDrive web URL you copied earlier, then save and test the connection.

Effortless Cloud Collaboration with WPS Office
If you are tired of complex path configurations and connection errors, consider switching to WPS Office. It provides an incredibly lightweight, free, and highly compatible alternative for handling complex spreadsheets and pivot tables, complete with built-in cloud sharing for seamless teamwork.
- 1. Download and Install: Get the free WPS Office suite from the official website and install it on your device.
- 2. Upload to WPS Cloud: Open your spreadsheet in WPS Spreadsheet and save it directly to your integrated WPS Cloud.
- 3. Share with Your Team: Click the 'Share' button in the top right corner to generate a secure collaboration link for your team members.

Frequently Asked Questions
Why does my Power Pivot connection show a C:\ path when I saved it to OneDrive?
Because the desktop OneDrive application synchronizes cloud files to a local directory on your hard drive. By default, applications like Power Pivot register this local file path instead of the cloud URL.
Do other users need direct access to the source file to refresh the data?
Yes, every user attempting to refresh the Power Pivot model must have explicit permissions granted in OneDrive or SharePoint to access the underlying source file.
What happens if I don't remove the '?web=1' parameter from the copied link?
Leaving web parameters at the end of the URL may cause Power Pivot to treat the source as a webpage rather than a raw data file, which typically results in an authentication or connection failure.
Can I use this method for standard Power Query connections?
Yes, changing local sync paths to direct SharePoint or OneDrive web URLs resolves similar multi-user refresh issues in standard Excel Power Query connections as well.




