Excel Spreadsheet Sharing: How to Send or Collaborate

How-to basics · Updated November 21, 2026

Yes—an Excel spreadsheet can be shared as a OneDrive or SharePoint link, or sent as a file attachment. I can help prepare its layout, formulas, or paste-ready data here; whether this chat can deliver a downloadable .xlsx file depends on the file-sharing tools available in the chat.

What it means to share an Excel spreadsheet

Sharing can mean two different things: giving someone access to the same cloud-stored workbook, or sending them a separate copy of the file. The distinction matters. With a shared OneDrive or SharePoint workbook, several people can work on one file and see updates. With an email attachment, each person receives an independent copy, so edits made to one copy do not automatically appear in the others.

A typical Excel workbook uses the .xlsx format. It can contain multiple worksheets, formulas, charts, tables, and formatting. Sharing a workbook does not necessarily mean sharing only the visible sheet: recipients with sufficient access may be able to inspect other sheets and workbook content. Before sending a file, check that it contains only information the recipient should receive.

If you are asking whether I can make one for you, I can help design the columns, generate example data, write valid Excel formulas, or format content so you can paste it into Excel. If this chat supports file creation or attachments, a downloadable workbook may also be possible; otherwise, you can use the instructions or data provided here to create the file in Excel.

Choose a link or a separate file

A link is usually the better choice when people need to collaborate on a single current version. The workbook is stored in OneDrive or SharePoint, and you control who can open it and whether they can edit. This approach avoids creating a new email attachment every time the workbook changes. It also gives you a place to review or change access later.

A separate file is useful when you want to provide a snapshot, send a copy to someone who does not need to collaborate, or preserve a version for a particular date. The recipient can edit the copy, but their changes will not update your original. If several people send back edited copies, you may need to compare or combine the changes yourself.

  • Use a shared link for ongoing work, shared schedules, project trackers, or a workbook that needs one source of truth.
  • Send a copy for a one-time handoff, an offline record, or a recipient who only needs a fixed version.
  • Use a PDF instead when the recipient only needs to read or print a report and should not edit the spreadsheet cells.

Share a workbook link in Microsoft 365

For Excel for Microsoft 365 on Windows, first save the workbook to OneDrive or a SharePoint document library. A file saved only on your computer cannot be shared as a live cloud workbook until it is uploaded to a supported cloud location. In Excel, use the Share button, commonly at the upper-right of the window, to open the sharing options. The precise choices can depend on whether you use a personal, work, or school account and on your organization’s settings.

  1. Open the workbook and save it to OneDrive or SharePoint. Check the name and location so you can find the cloud copy later.
  2. Select Share. If prompted, sign in to the account that has access to the cloud location.
  3. Choose the access level, such as allowing recipients to edit or limiting them to viewing, where those options are available.
  4. Enter the intended recipients or create a link using the available link settings. Some organizations restrict link sharing or permit links only for specific people.
  5. Send the invitation or copy the link and deliver it through an appropriate channel. Confirm that the recipients can open it before relying on it for time-sensitive work.

Excel for the web also offers sharing controls for workbooks stored online. On a Mac, the Share control and cloud-storage workflow are broadly similar, but the arrangement of commands and account prompts can differ from Windows. If the workbook is local, save or move it to OneDrive or SharePoint first. Avoid assuming that a recipient can open a link just because it works for you: their account, organization rules, and the permission selected all affect access.

Set viewing and editing permissions carefully

Editing access allows a recipient to change workbook content. Viewing access is appropriate when someone needs to read the information without changing the shared file. Available controls can include link audiences such as specific people or people in an organization, but not every account offers every option. A workplace administrator may disable broad links, for example, to keep files within the organization.

Choose the narrowest access that still lets the recipient do the task. If only a few named collaborators need the workbook, a link restricted to those people is generally clearer than a broadly usable link. Do not treat a link as secret merely because you sent it privately: recipients may be able to forward it depending on its settings. Review the sharing dialog before sending, and use the service’s access-management controls if you need to change or remove access later.

Worksheet protection and sharing permissions are not the same thing. Protecting a sheet can limit editing of cells, but it should not be treated as a substitute for controlling who can access the workbook or as a guarantee that confidential information is hidden. Hidden sheets and hidden rows are not a reliable way to keep data secret from someone who can access the workbook. Remove sensitive content that the recipient should not see.

Send an Excel file as an attachment

To send a separate workbook, save it in .xlsx format and attach that file using your email or messaging application. The attachment is a copy at the time you send it. If you later change your original, the recipient’s downloaded copy will not update. A practical way to avoid confusion is to include the date or version in the file name, such as Monthly-Report-November.xlsx, and explain whether the recipient should edit and return it.

Excel workbooks can be large, and some email services limit attachment size. If the file is too large, use an approved OneDrive or SharePoint link instead of repeatedly compressing or resending it. If the recipient only needs the data, CSV may be suitable, but CSV is not a full Excel workbook: it stores plain tabular text for one sheet and does not preserve workbook features such as formulas as formulas, formatting, charts, or multiple worksheets. Open a CSV carefully and save a separate .xlsx copy if you need those features.

For a small example workbook, suppose cells A1:B4 contain item names and amounts, with amounts in B2:B4 equal to 18, 27, and 15. Put a total label in A5 and, with those amounts in B2:B4, enter =SUM(B2:B4) in B5. The result is 60. This illustrates how you can prepare a useful sheet before sharing it; the person receiving an editable workbook can change the amounts and the total will recalculate.

What happens when people edit together

When a workbook is stored in OneDrive or SharePoint and shared with editing access, compatible Excel versions can support coauthoring. Collaborators may see one another’s changes as they work, though updates can take time to appear and network or account issues may interrupt access. For the smoothest collaboration, keep the file in a supported modern workbook format such as .xlsx and use a current version of Excel or Excel for the web.

Agree on how the workbook should be used before several people edit it. A shared expense log, for example, might have one row per transaction and clearly named columns for date, description, category, and amount. If people enter information in different formats or overwrite headings and formulas, the shared file can become harder to use even when the technology is working correctly. Consider marking input cells clearly and explaining which cells contain formulas.

Coauthoring is different from sending a workbook to people who then edit downloaded copies. If collaborators return separate versions, Excel cannot assume which changes should take priority. You may need to compare versions manually. Keeping the shared file as the agreed source of truth, and making a separate backup before major changes, can reduce that confusion.

Check privacy and file contents before sending

Spreadsheets can contain more than what appears on the screen. Before sharing, inspect hidden worksheets, hidden rows and columns, comments or notes, and any extra data that is not meant for the recipient. Also check for personal information, customer details, confidential figures, and old test data. If a workbook was copied from another project, confirm that its tabs and labels belong in the new file.

Think about the recipient’s needs as well as confidentiality. A person who only needs to review a finished report may be better served by view-only access or a PDF. Someone who needs to update a tracker needs editing access to the right workbook. If the file contains sensitive business or personal information, follow the rules of your organization or the relevant service rather than choosing the most convenient sharing option by default.

Common sharing problems and alternatives

If a recipient says the link does not work, check that the workbook is actually stored online, that you shared the intended file, and that the recipient is signed into an account permitted by the link settings. A work or school account may block external access. Ask the recipient for the exact error message, then review the file’s sharing permissions rather than sending a new unrestricted link immediately.

If someone can open the workbook but cannot edit it, the link may be view-only, or the recipient may have opened a different copy. Check the permission attached to the invitation and confirm that they are using the shared cloud file rather than an attachment downloaded earlier. If multiple copies have already circulated, identify which version should be treated as authoritative before merging changes.

There are also alternatives to sharing an editable Excel workbook. A PDF is useful for a stable, readable report; a CSV can transfer simple table data between applications; and an image can show a small chart or range when editing is unnecessary. These formats do not replace an Excel workbook when recipients need formulas, multiple worksheets, or ongoing collaborative editing, so choose based on what the recipient must actually do.

Frequently Asked Questions

Can you share an Excel spreadsheet with me here?
I can help create spreadsheet content, formulas, or a layout in the chat. Whether I can attach a finished .xlsx file depends on whether this chat provides file-generation and download features. If not, I can give you paste-ready data and steps to build it in Excel.

Can I share an Excel spreadsheet with someone who does not have Excel?
They may be able to view or edit a workbook in Excel for the web if they can access the shared link and meet its sign-in requirements. Access depends on the link permissions and account settings. For a read-only report, a PDF may be simpler.

Can two people edit the same Excel spreadsheet at once?
Yes, compatible Excel versions can support coauthoring when the workbook is stored in OneDrive or SharePoint and both people have editing access. The experience depends on the file format, software version, account, and connection. Sharing separate email attachments does not create one jointly edited file.

How do I stop someone from changing a shared workbook?
Set their access to view-only if that option is available, or change or remove their access using the workbook’s sharing controls. If they already downloaded a copy, changing cloud permissions does not remove that separate file from their device.

Is it safer to send a link or an attachment?
Neither choice is automatically safer in every situation. A cloud link can offer adjustable permissions, while an attachment creates a copy that may be forwarded or stored elsewhere. Choose the method allowed by your organization, limit access to intended recipients, and remove information they do not need.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.