Yes. You can share an Excel workbook that contains Power Query through OneDrive or SharePoint, but sharing the workbook does not automatically give collaborators permission to the query’s source data or its sign-in credentials. They can see the saved workbook contents; to refresh a query, each person or the shared environment must also be able to reach and authenticate to the source.
What sharing a Power Query workbook means
A Power Query workbook can contain several different things: the query instructions, a connection to a data source, and the data that was last loaded into a worksheet or the Data Model. Those parts have different access requirements. The query definition describes how data is collected and transformed. The loaded results are a snapshot in the workbook, while a refresh asks Excel to retrieve current data again.
For example, suppose a workbook imports a sales CSV from a folder on one employee’s computer. A colleague might open the shared workbook and see the last loaded sales table, but the query may fail for that colleague because the original computer path is unavailable. If the source is a SharePoint list, the colleague still needs permission to that list, even if they can open the workbook stored in SharePoint.
So, “share the file” and “share access to the data” are separate tasks. Before sending a link, decide whether recipients need only the existing results, or whether they must be able to refresh and update them.
What collaborators can see and do
When recipients open a workbook, they can generally view the saved worksheet data and any other content they have permission to access in that file. Depending on the workbook and their Excel version, they may also be able to inspect or edit queries, refresh connections, and change the loaded results. Sharing a workbook should not be treated as a way to conceal the query logic or the data already saved inside it.
A user who has access to a workbook does not necessarily have access to its source. For example, an external recipient may be able to open a file shared from OneDrive but be denied access to an internal database. Likewise, a recipient’s access to a source does not guarantee that the query will work: the source may require a supported connector, a compatible network connection, or credentials that Excel can use.
Check the workbook for information that should not be distributed before sharing it. Removing a worksheet from view or protecting a sheet is not a reliable substitute for controlling access to sensitive data. If recipients should not see particular records, remove or appropriately filter that data before distributing the workbook, and confirm that the saved results do not expose it.
Share the workbook through OneDrive or SharePoint
For Microsoft 365 collaboration, store the workbook in OneDrive or a SharePoint document library and use Excel’s sharing controls. In Excel for Microsoft 365 on Windows, select Share near the upper-right corner, or use File > Share. Choose or create a link, set whether recipients can edit or only view, and share it with the intended people. The exact options can depend on your organization’s sharing policies.
- Save the workbook to OneDrive or SharePoint, rather than leaving it only on a local drive.
- Select Share and choose the people or group who need the file.
- Set their workbook permission to view or edit, as appropriate, and send the link.
- Separately grant access to the query’s source if those people need to refresh it.
- Ask a recipient to open the shared copy and test the actions they will need, such as refreshing a query.
OneDrive and SharePoint support collaborative editing for many Excel workbooks, but a shared file is not automatically suitable for every simultaneous workflow. A refresh changes the workbook’s loaded data. Coordinate refreshes and edits if users rely on a consistent snapshot, and make sure the workbook is saved after the required results are loaded. A person who has view-only access cannot use the file as though they had permission to change and save its contents.
Source permissions and credentials are separate
Power Query’s data source credentials are not a general-purpose access pass that travels with a shared workbook. Authentication is often tied to the individual user, the data source, or the environment in which a query runs. A recipient may be prompted to sign in, receive an access error, or see a privacy-level prompt when refreshing. Do not send passwords in the workbook or assume that sharing a link distributes credentials safely.
Before sharing, identify each source and decide how recipients should authenticate. A workbook might combine a public web file with a company database; each source can have different permission rules. If a source uses a local file path, recipients need a path they can access. A centrally stored file or an organization-approved shared location is usually more practical than a path such as a user’s desktop folder.
In Excel for Windows, review available connections through Data > Get Data > Data Source Settings. The Queries & Connections pane, available from the Data tab, can help identify workbook queries and connections. These views help you understand what a workbook uses; they do not grant collaborators permission to the sources. For business databases or managed cloud sources, ask the data owner or administrator which authentication and access method is approved.
Refresh behavior in desktop Excel and the web
In desktop Excel for Microsoft 365 on Windows, a user can generally refresh queries using Data > Refresh All or by refreshing an individual query from the Queries & Connections pane. The available refresh choices depend on the connection and query. A successful refresh requires more than an editable workbook: Excel must be able to connect to the source and complete any required sign-in.
Excel for the web can refresh some Power Query sources, but support varies by connector, workbook setup, and organizational environment. Its Power Query capabilities are not identical to desktop Excel, and not every desktop query or source can be refreshed or edited in a browser. If a recipient’s task depends on a particular connector or transformation, verify that exact workflow in the browser before relying on it. Desktop Excel for Windows generally offers the broadest Power Query experience.
Excel for Mac also includes Power Query capabilities in Microsoft 365, but supported connectors and features can differ from Windows. If collaborators use Mac, web, or older Excel versions, test with the actual workbook and source rather than assuming the same refresh experience on every platform.
Choose a sharing setup that fits the task
The right approach depends on what recipients need to accomplish. Sharing a workbook with saved results is different from giving a team a reliable, repeatable refresh process. Consider the source’s sensitivity, the recipients’ permissions, and whether one person or many people should control updates.
- Recipients only need to read a snapshot: Share a view-only workbook containing the intended loaded results. Confirm that it contains no data or query details that should remain private.
- Recipients need to refresh from a shared file: Put the source in an approved shared location, grant each recipient the necessary source permission, and test their sign-in and refresh process.
- Recipients need a report but not the raw source: Share a carefully prepared output workbook or export, and avoid including connections or unnecessary source records. Remember that an exported snapshot will not refresh itself.
- A team needs managed, repeatable distribution: Ask whether an organization-supported reporting or data platform is more appropriate than having many people refresh a workbook independently.
These are access and workflow choices, not simply Excel settings. A workbook may be technically shareable while still being a poor place to distribute confidential data or coordinate a process that requires controlled refreshes.
Common problems and practical checks
A query that works for its creator but fails for a recipient usually points to a difference in access, credentials, paths, or supported features. Start by checking the source and the exact error, rather than repeatedly changing query steps that may already be correct.
- File or folder not found: The query may use a path on the creator’s computer. Move the source to a location the intended users can access, then update the query’s source reference.
- Access denied or sign-in prompt: The recipient may lack source permission or need to authenticate with their own account. Workbook permission alone does not resolve this.
- Refresh works in Windows but not in a browser: The connection or query may not be supported for that web refresh scenario. Use the required desktop version or choose a compatible source and workflow.
- Different results after refresh: The source may have changed, or users may have different access or filters. Compare the source, query steps, and refresh time before treating the results as equivalent.
- Recipient can see more than expected: Review the saved tables, worksheets, and query outputs before sharing. A query that is not currently refreshed can still leave previously loaded records in the workbook.
For a useful handoff, tell recipients which Excel environment to use, which source they need access to, and whether they should refresh the workbook. If a particular saved result is the approved version, include its refresh date in the workbook or accompanying instructions.
Frequently Asked Questions
Can someone refresh a Power Query workbook if they only have the Excel file?
Not necessarily. They also need access to the source, valid authentication, and an Excel environment that supports that connection and query. They may still be able to view results that were saved in the workbook.
Are Power Query credentials shared with the workbook?
Do not assume they are. Credentials are handled according to the source and user or environment, and a recipient may need to sign in separately. Never put a password in a workbook as a substitute for proper access controls.
Can I share an Excel Power Query file with someone outside my organization?
Yes, if your organization allows external sharing and you grant the recipient permission to the workbook. They will also need permission to any restricted source if they are expected to refresh it. Check sharing policies and remove sensitive saved data they should not receive.
Can recipients use Power Query in Excel for the web?
Some Power Query refresh and editing scenarios are available in Excel for the web, but support is not identical to desktop Excel and varies by source and workbook. Test the recipient’s exact task in the browser before depending on it.
How can I share results without allowing people to refresh?
Give recipients view-only access to a workbook or a separate output containing only the approved results. A static export is another option, but it will not update from the source. Check that the shared copy does not include unwanted data or connections.
Bottom line
You can share an Excel workbook containing Power Query, but the workbook link controls access to the file, not automatically to every data source behind it. Decide whether recipients need a saved snapshot or a working refresh process, grant source access separately, and test the complete workflow in the Excel version they will use. That distinction prevents most surprises when a colleague opens a query-driven workbook.
Related
- Electronic Inventory Tracking in Excel: Setup and Tips
- Elton John at Xcel Energy Center: Date and Details
- Elton John Xcel Energy Center Parking: What to Know
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Can You Create Outlook Rules in OWA? Here’s HowYes. You can create and manage Outlook rules in Outlook on the web (OWA) to sort incoming email,…
- Excel Shortcut to AutoFit Column Width on Windows and MacIn Excel for Microsoft 365 on Windows, select the column or columns, then press Alt, H, O, I…
- Attendance Log Excel Template: Build One That WorksAn attendance log Excel template is a worksheet for recording who attended, when they arrived or left, and…
- How to Work Out Percentages in Google Sheets EasilyTo work out a percentage in Google Sheets, divide the part by the total, then format the result…
- Google Sheets DATEDIF: Calculate Days, Months, and YearsGoogle Sheets’ DATEDIF function calculates the time between two dates in whole days, months, or years. Enter a…
- Excel Indent Shortcut: Increase or Decrease Cell IndentIn Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, H, 6 to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.