How to Share an Excel File as a Link (View-Only, No Download) in 2026

How to Share an Excel File as a Link (View-Only, No Download) in 2026

Last updated: September 2026

Quick answer: To share an Excel file as a link, save it to OneDrive or SharePoint, select Share in the upper-right corner of Excel, choose Copy link, open the link settings to set Can view and who the link works for, then paste the link. There are four ways to do it: (1) Excel's own Share button, (2) the Share dialog in OneDrive or SharePoint, (3) Google Sheets with a Viewer link, and (4) a password-protected, view-only data room link for financial models and cap tables. If the formulas must stay private, export to PDF first.

I'm Deqian Jia, co-founder of Peony, a data room company. A large share of the spreadsheets our 6,800+ customers upload are shared as links because the sender was tired of version chaos from attachments, or because the recipient could not be trusted with a downloadable file. Most of the time you do not need us: Microsoft's built-in link sharing is good, and I will show the exact clicks first. Then I will be honest about where the native link stops and a controlled link starts.

How do I share an Excel file as a link?

Select Share in Excel, choose Copy link, and paste the link. The workbook must already live in OneDrive or SharePoint; if it is on your desktop, Excel will ask you to upload it first.

Microsoft's co-authoring help gives the steps per platform (support.microsoft.com). The workbook has to be in ".xlsx, .xlsm, or .xlsb file format" and stored on OneDrive, OneDrive for Business or SharePoint Online.

1. Save the file to OneDrive or SharePoint. In Excel, File, Save As, and pick your OneDrive or a SharePoint site. Once it is in the cloud, the Share button becomes active.
2. Select Share. On Windows it is in the upper-right corner. On Mac, Microsoft's help says to press Esc and then select Share > Copy link. In Excel for the web, click Share at the top.
3. Open the link settings. Select the gear icon (or Link Settings in Excel for the web) to choose who the link works for and whether they can edit.
4. Set the permission. Microsoft's OneDrive help says copied links default to Can edit, so switch to Can view unless you want edits (support.microsoft.com).
5. Select Apply, then Copy. Paste the link into email, Teams, Slack or a doc. Anyone who opens it sees the current version, and if you want to invite by email instead, type addresses separated by semicolons and select Send.

That is the whole method for the ordinary case: a budget going to a colleague, a price list going to a supplier. The rest of this post is about making the link behave.

How do I make an Excel link view only?

Change the permission from Can edit to Can view in the link settings before you copy the link, and narrow the audience.

Microsoft's OneDrive sharing dialog offers four audiences (support.microsoft.com):

• Anyone gives "access to anyone who receives this link", signed in or not.
• People in your organization with the link works only for accounts in your tenant.
• People with existing access "does not change any permissions"; it just produces a link for people who already have access.
• Specific people "gives access only to the people you specify".

Then the permission: Can edit or Can view (Word files also get Can review). Two more controls sit in the same dialog: Set expiration date and Set password, which Microsoft marks as "only available to Microsoft 365 subscribers", and for folders only on Anyone links. If an option is greyed out, Microsoft's help says your organization's admins may have restricted it, for example disabling Anyone "to prevent usable links being forwarded to others outside your organization".

A view-only link is a real restriction on editing the original. It is not a restriction on copying: a viewer can still select cells, copy values, download the file (unless you block it, next section) or screenshot it.

Can I share an Excel file without letting people download it?

Sometimes. Microsoft's dialog has a Block download switch, but it only appears for work or school accounts and only on links that do not allow editing.

Microsoft's wording is exact: "Block download prevents people from downloading the file or folders they have access to", and it is "only available for work or school accounts and if you don't allow editing" (support.microsoft.com). So:

• Personal Microsoft accounts (outlook.com, hotmail.com) do not get Block download.
• A Can edit link cannot block download.
• With Block download on, the recipient reads the sheet in Excel for the web only.

What Microsoft's sharing help does not describe is anything that stops the viewer from copying cell values out of the browser, taking a screenshot, or seeing who else opened the link. For a cap table going to an investor or a model going to a buyer, that is the gap a data room closes, and I cover it below. For everything else, Can view plus Block download is enough.

How do I share an Excel link from OneDrive or SharePoint directly?

Right-click the file in OneDrive or in a SharePoint document library, select Share, and you get the same dialog with the same settings.

This route is useful when you do not want to open the workbook, or when you are sharing a folder of spreadsheets at once. The steps are identical: Share, adjust the settings via the gear icon, Apply, then Copy and Send (support.microsoft.com). Folder links carry the same expiration and password rules as file links, restricted to Anyone sharing.

If your company has both OneDrive and SharePoint and you are not sure which the file should live in, the usual rule is simple: your own working files go in OneDrive, team files go where the team works. I walked through the storage and sharing differences in SharePoint vs OneDrive, and the security posture in Is OneDrive secure?.

How do I share an Excel file as a Google Sheets link?

Upload the .xlsx to Google Drive, open it (it opens in Google Sheets), set General access to Anyone with the link or keep it Restricted, choose Viewer, and select Copy link.

Google's help confirms an Excel file double-clicked in Drive "opens in Google Sheets", and you can either edit it in Excel format or click File, then Save as Google Sheets to convert it; Google recommends converting when "your dataset is 10 million cells or fewer" and keeping Excel for larger sets or rare chart types (support.google.com).

Sharing then follows Drive's standard dialog (support.google.com):

1. Select Share.
2. Under General access, pick Restricted ("only people with access can open the file") or Anyone with the link ("anyone who has the link can use your file, without signing in to their Google Account").
3. Set the role to Viewer, Commenter or Editor.
4. To stop downloads, select Share, then Settings, and untick the option that lets viewers and commenters download, print and copy.
5. Select Copy link.

Google's Add expiration control is "only available for eligible work or school accounts", and viewers who are not signed in "show up as anonymous animals", so you see an anonymous animal while they are in the sheet, not who they were or when they came. If the sheet needs a password rather than a Google login, see how to password protect Google Sheets.

Should I convert the Excel file to PDF before sharing the link?

Yes, when the formulas, hidden sheets or cell comments must not travel with the numbers. A PDF shows the printed values and nothing else.

In Excel, use File, Save As (or Export) and choose PDF as the file type, checking the print area first so wide sheets do not spill across pages. Then share the PDF the same way, as a OneDrive link or through a data room. The trade-off is obvious: recipients cannot sort, filter or plug in their own scenarios, and you lose the single live version. For a lender who needs three tabs of a model and nothing behind them, that is often the right trade. If you go this route, the same view-only and no-download logic applies; I covered the mechanics in how to send a password-protected PDF.

When should I use a data room link instead of an Excel link?

When the spreadsheet is a financial model, cap table, pricing book or anything a counterparty could misuse, and you need to know who opened it, stop downloads regardless of account type, and be able to pull the link back.

I run Peony, so weigh this accordingly, but the feature line is factual. A data room link wraps the workbook in a viewer that the native Share dialog does not provide:

• Password-protected link, expiry date and per-viewer analytics on the free plan. You upload the .xlsx, generate a link, set a password and an end date, and see each open by viewer email with time on each sheet. No Microsoft or Google account is needed on either side.
• Download prevention, screenshot protection, email authentication and revocation on Business ($30 per admin per month billed annually, $44 monthly). View-only means view-only for any recipient, not just work-or-school tenants, and you can revoke a link after the fact.
• Dynamic watermark on Data Room ($52 per admin per month billed annually, $75 monthly): every page carries the viewer's email and timestamp, so a screenshot that leaks points back to its source. Data Room also adds signed NDAs and a custom domain.

Steps in Peony take about two minutes: create a room or a single-file link, upload the workbook, open link settings, set the password and expiry, toggle off download (Business), and copy the link. Full tier detail is on pricing and security.

Where Peony is not needed: a sheet shared inside your own company, a collaborative budget that people must edit, or anything you would happily attach to an email anyway. OneDrive with Can view covers those, and 6,800+ customers use both Microsoft's links and ours for different files. If you want protection inside the file itself, the companion guides are how to password protect Excel files and how to add a watermark in Excel; if you are choosing between OneDrive and a data room more broadly, see virtual data room vs OneDrive.

Which method should I use to share an Excel file as a link?

Frequently asked questions

How do I share an Excel file as a link?

Save the workbook to OneDrive or SharePoint, select Share in the upper-right corner of Excel (Windows, Mac or Excel for the web), then choose Copy link. Open the link settings (the gear icon) to pick who the link works for and whether recipients Can edit or Can view, select Apply, and paste the link into your email or chat. The recipient opens the live workbook in a browser without downloading an attachment.

How do I share an Excel file as view only?

In the Share dialog, open the link settings and change the permission from Can edit (the default for copied links) to Can view before you copy the link. If you also want to restrict who can use it, pick Specific people or People in your organization instead of Anyone. For a view-only link that also blocks downloading and tracks each viewer, upload the file to a data room such as Peony and share a password-protected link with download disabled on the Business plan ($30 per admin per month, billed annually).

Can I share an Excel file without letting people download it?

Partly. Microsoft's OneDrive sharing dialog has a Block download switch, but Microsoft states it is only available for work or school accounts and only when the link does not allow editing, so personal accounts and Can edit links cannot use it. Google Sheets lets owners untick the option for viewers and commenters to download, print and copy. Peony blocks download on every tier from Business ($30 per admin per month) upward and adds screenshot protection, so the recipient can only read the sheet in the viewer.

Can I share an Excel file with someone who does not have Excel?

Yes. A OneDrive or SharePoint link opens the workbook in Excel for the web inside the browser, so the recipient needs no desktop Excel. If you set the link to Anyone, they do not need a Microsoft account either. Alternatively, open the file in Google Sheets and share a Viewer link, or upload it to Peony, which renders spreadsheets in the browser for any viewer with the link and password. If formulas must stay private, export the sheet to PDF first and share that.

How do I stop a shared Excel link from being forwarded?

A link set to Anyone works for whoever receives it, so forwarding cannot be stopped; instead set the link to Specific people, which grants access only to the addresses you name, or People in your organization. Microsoft also notes admins may disable the Anyone option for this reason. In Peony, require email authentication (Business, $30 per admin per month) so the link only opens for approved addresses, add a password and an expiry date (available on the free plan), and revoke access the moment you see an unexpected viewer.

Can I see who opened my shared Excel file?

OneDrive and SharePoint show who has access and basic activity on the file, but Microsoft's sharing help does not describe per-viewer, per-page open tracking as a native feature, and a link set to Anyone shows no identity at all. Google Sheets shows anonymous viewers as animals unless they sign in. Peony records every open by viewer email, with time spent per sheet and page, on every plan including Free, which is why 6,800+ customers use it for models and cap tables.

How do I share an Excel file as a link that expires?

In the OneDrive Share dialog, open the link settings and use Set expiration date; Microsoft notes this option is only available to Microsoft 365 subscribers and, for folders, only on Anyone links. Google Drive offers Add expiration on eligible work or school accounts. Peony includes link expiration on every plan, including Free, and you can also revoke a link manually on Business and above.

What is the safest way to share a financial model or cap table as a link?

Upload the workbook to a data room and share a single link with a password, expiry date, email authentication and download disabled, so viewers read it in the browser and you see who opened which sheet. In Peony, password links, expiry and per-viewer analytics are free; download prevention, screenshot protection and email authentication are on Business ($30 per admin per month, billed annually); dynamic watermarks that stamp each viewer's email on every page are on Data Room ($52). Peony is rated 4.8 on G2 and 4.9 on Capterra and serves 6,800+ customers.