How to Share Excel Data: Links, Files, Word, and PDF

“Share this spreadsheet” can mean several different things. One recipient may need to edit the same workbook with you, another may need a fixed report, and a third may need a small table inside a Word document. Using the wrong method creates duplicate files, broken links, or more access than the recipient needs.

The first decision is not which button to select. It is what the recipient should be able to do after receiving the data. Once that outcome is clear, Excel’s sharing choices become much easier to manage.

Menu paths below use current Excel for Microsoft 365 on Windows. Excel for Mac and Excel for the web support cloud sharing and co-authoring, although some dialog labels and desktop-only paste features differ.

Choose the sharing method by the desired outcome

A sharing link is usually the cleanest choice for ongoing collaboration because it avoids emailing a new attachment after every revision. A separate file is better when the recipient needs an independent record or cannot access the cloud location.

Prepare the workbook before anyone else sees it

Sharing exposes the workbook, not only the cells currently visible on screen. Review the whole file before creating a link or attachment:

• Confirm the workbook name, version, storage location, and file format.
• Review every worksheet, including hidden sheets, rows, and columns.
• Check comments, notes, named ranges, external links, queries, and data connections.
• Remove temporary calculations, copied source data, and personal details the recipient does not need.
• Check whether formulas or charts depend on files the recipient cannot access.
• Open the workbook as the intended recipient would and verify the important views, filters, and instructions.

Inspect a copy for hidden information

Desktop Excel for Windows includes Document Inspector. First save a copy, then open File > Info > Check for Issues > Inspect Document. Review the findings before removing anything. The inspector can identify items such as comments, document properties, hidden rows, hidden columns, hidden worksheets, and some external content.

Document Inspector helps you review hidden metadata, comments, and other content before sharing a workbook with other people.

Run Document Inspector on a copy, not your only working file. Some removals cannot be undone, and deleting hidden rows, columns, or sheets can change formulas and results.

Microsoft’s Document Inspector guide lists what the tool can detect, remove, or only report.

Share one live workbook for collaboration

Excel’s modern co-authoring workflow keeps the workbook in OneDrive, OneDrive for work or school, or SharePoint Online. People with edit access can work in the same file instead of exchanging copies.

1. Save or move the workbook to an available OneDrive or SharePoint location.
2. Open the workbook and select Share.
When a workbook is stored locally, Excel asks you to save it to an online location before you can use live sharing and collaboration features.

3. Open the link or permission settings and choose who should have access.
4. Choose whether recipients can edit or can only view.
5. Enter names or email addresses and select Send, or choose Copy Link and send the link through your usual communication channel.
6. Reopen the sharing controls and confirm the final audience and permission level.

The wording in the Share dialog varies between personal and work or school accounts. Organization administrators can also restrict external sharing or disable some link types. Microsoft’s Excel workbook-sharing instructions cover the current Windows and Mac workflow.

Choose the smallest useful audience

Not every account displays every audience. When in doubt, use a named audience and view-only permission, then expand access only if the work requires it.

Make co-authoring easier to control

Co-authoring lets several people edit a supported cloud workbook at the same time. It works best when everyone uses a current co-authoring version of Excel or Excel for the web.

• Keep AutoSave on: changes reach the shared cloud file and become visible to collaborators.
• Use comments for discussion: keep decisions beside the relevant cells instead of creating unexplained edits.
• Use Show Changes when available: review recent cell edits and previous values.
• Divide responsibility: assign worksheets or ranges when several people might edit the same area.
• Use Version History for recovery: in desktop Excel for Microsoft 365, open File > Info > Version History to review earlier cloud versions.

A file can become locked if someone opens it with an Excel version that does not support co-authoring. If a collaborator cannot use a current desktop app, ask them to edit in Excel for the web. Microsoft’s co-authoring guide lists supported storage, formats, apps, AutoSave behavior, and common lock problems.

Co-authoring reduces duplicate files, but it does not remove the need for clear ownership. Decide who maintains the workbook structure, who enters data, and who approves final results.

Send an independent Excel copy when synchronization is unwanted

An attachment is appropriate when the recipient needs a separate editable file, a dated record, or access outside your cloud environment. Create a copy rather than casually attaching the active working file.

1. Use File > Save a Copy or Save As.
2. Give the copy a clear name that identifies its purpose or date.
Use Save As to create a separate Excel workbook copy when the recipient needs an editable file that does not stay synchronized with the original.

3. Keep the original format when the workbook relies on features such as VBA macros.
4. Open the copy, confirm that formulas and links behave as intended, and inspect it for hidden information.
5. Send the copy with a short note explaining whether it is for review, editing, or recordkeeping.

Once sent, the copy is independent. Your later edits do not appear in it, and the recipient’s edits do not return to your source workbook automatically. If both sides will keep making changes, a shared cloud file is usually easier to reconcile.

Do not change a macro-enabled .xlsm workbook to .xlsx merely to make the filename look familiar. The .xlsx format does not store VBA macro code.

Export a PDF for a fixed report

PDF is useful when the recipient should read, archive, or print a report rather than edit formulas and cells. It also lets you share selected sheets or a defined print layout without distributing the full workbook structure.

1. Set the print area, page orientation, margins, scaling, and repeated headings.
2. Open File > Save As or Save a Copy.
3. Choose PDF as the file type.
Choose PDF in the Save As dialog to export a workbook as a fixed report that recipients can view or print without editing the original Excel file.

4. Open Options and confirm whether the selection, active sheet, or workbook should be included.
Use the PDF Options dialog to control whether Excel exports the current selection, the active sheet, or the entire workbook.

5. Save the PDF, then open it and inspect every page before sharing it.

Check Excel Print Preview to confirm that the table fits the page and the print settings look correct before creating or sharing a PDF report.

A PDF is a presentation format, not a permission system. Anyone who receives the file may be able to keep or forward a copy. Use an access-controlled sharing method when the report is sensitive.

Microsoft’s PDF conversion instructions explain Excel’s output scope and quality options.

Reuse Excel data in Word, PowerPoint, or Outlook

Copying Excel content into another Office app offers several distinct results. Choose based on whether the destination should match its own design, preserve Excel formatting, update from the workbook, or remain completely self-contained.

Paste a static Excel range

1. Select the Excel cells and press Ctrl+C.
2. Place the cursor in Word, PowerPoint, or Outlook and press Ctrl+V.
3. Open Paste Options.
4. Choose Use Destination Styles, Keep Source Formatting, or Picture.
5. Check column widths, wrapping, borders, and page fit in the destination.

This method creates a snapshot. Editing the Excel workbook later does not change the pasted table or picture.

Paste a linked table or chart

1. Save the Excel workbook in a stable location that the destination file can continue to reach.
2. Copy the Excel range or chart.
3. In the destination app, open the Paste menu or Paste Special.
4. Choose a link option such as Link & Keep Source Formatting or Link & Use Destination Styles. For a chart, choose the equivalent Link Data option.
5. Save both files and verify that the destination can refresh from the source.

Linked content stores the source location rather than a complete independent workbook inside the destination. Moving, renaming, or removing access to the source can stop updates. If another person must refresh the content, that person also needs a usable path and permission to the source.

Embed an editable Excel object

An embedded object stores a copy of the Excel content inside the Word or PowerPoint file. Double-clicking the object opens Excel editing tools, but later changes to the original workbook do not update the embedded copy. Embedded workbooks can also increase the destination file size and may contain more underlying data than the visible object shows.

Microsoft’s Office paste-options guide compares static, linked, and picture choices, while its linked and embedded object reference explains where each type stores its data.

Review and remove access after sharing

Sharing is not finished when the message is sent. Owners should periodically check who can open the workbook and which links still grant access.

1. Open the file’s Share dialog or locate it in OneDrive or SharePoint.
2. Open Manage Access.
3. Review people with direct access, groups, and active sharing links.
4. Remove people who no longer need access or delete an obsolete link.
5. If a link has the wrong permission, delete it and create a new link with the correct setting.

Removing cloud access does not erase copies that recipients already downloaded or forwarded. Share the minimum necessary data from the beginning, and use organizational retention or information-protection controls when policy requires them.

Microsoft’s permission-management guide covers direct access, sharing links, permission changes, and stopping access.

Troubleshoot common sharing problems

Frequently asked questions

Match access to the job

Good Excel sharing is less about sending data and more about choosing the right relationship between files and people. Use one controlled cloud workbook for ongoing collaboration, a separate workbook when the recipient needs an independent copy, a PDF for a fixed report, and the appropriate paste method for Word or PowerPoint. Then revisit access after the work is finished.