How to Embed a File in Excel | One Menu Does It

Feed / By

You can embed a file in an Excel worksheet using the Object tool on the Insert tab in the desktop app.

One menu path handles how to embed a file in Excel. Whether it’s a PDF, a Word document, or another spreadsheet, the Object dialog in the desktop app is the right tool. This guide walks through the exact steps to embed a file, explains the key differences between embedding and linking, and covers what works — and what doesn’t — in Excel for the web.

What Does Embedding a File Actually Do?

Embedding a file in an Excel worksheet places a static copy of the source document inside your workbook. Unlike a hyperlink, it does not break if the original file moves. The file appears as an icon or a preview of the first page. Double-clicking the object opens the complete file in its native application.

The Exact Steps to Embed a File in Excel

The desktop Excel app is the only place where you can embed a file directly into a worksheet using the Insert Object dialog. Microsoft’s official documentation for inserting an object in your Excel spreadsheet confirms this is the standard workflow.

  1. Click the cell where you want the object to appear.
  2. Go to the Insert tab.
  3. Find the Text group on the far right.
  4. Click Object.
  5. Select the Create from File tab.
  6. Click Browse and locate the file on your computer.
  7. Choose how it displays:
    • Check Display as icon to show a representative file icon.
    • Leave it unchecked to show a thumbnail preview of the first page.
  8. Click OK. The object is now embedded in the active cell.

Embedding vs. Linking — What’s the Difference?

Embedding stores the file inside the workbook. Linking creates a live reference to the external file. Choosing the right one depends on how you plan to share and update the workbook. Microsoft’s video on embedding and linking files breaks down the use cases.

Here is a comparison of the two approaches:

Feature Embed Link
What it creates A static copy inside the workbook A reference to an external file
Impact on file size Increases by the size of the embedded file Minimal increase
Updates when source changes No — it is a snapshot Yes — reflects the current version
Breaks if the source is moved or renamed No Yes — the link path is invalid
Best for Sending a standalone workbook to others Teams collaborating on shared drives
Configuration Default Insert Object behavior Requires checking “Link to file”
Security The file is contained inside the workbook Dependent on the security of the source path

The Main Difference in Excel for the Web

Excel for the web does not support embedding local files into a worksheet. The “Embed” option available in the browser is for generating an HTML iframe code to publish a workbook stored on OneDrive. It is meant for sharing a full workbook on a blog or website, not for inserting a PDF or Word document into a cell.

Finding Every Embedded Object on a Sheet

Locating all embedded objects in a workbook requires a per-sheet search. Excel’s built-in object finder only scans the active sheet.

Here is the process to find embedded items:

  • Press Home > Find & Select > Go To Special.
  • Select Objects and click OK.
  • Excel selects every object on the current sheet.
  • Repeat this step for every sheet in the workbook, including sheets that may be hidden.

Common Mistakes and Practical Fixes

The most frequent errors come from using the wrong Excel version or misconfiguring the Object dialog options. Here is a quick reference for the most common issues:

Mistake Why It Happens The Fix
Using Excel for the web to embed a local PDF The browser version lacks the Insert Object feature for local files Open the workbook in the Excel desktop application
The embedded object does not update Embedding creates a static snapshot of the source file Delete the old object and repeat the embed process with the updated file
Cannot find an embedded object on a sheet Go To Special only scans the currently active sheet Run Find & Select on each sheet manually
The Object button is grayed out The sheet is protected or the workbook is in shared mode Unprotect the sheet or unshare the workbook
Embedded file opens in a new window Default operating system behavior for certain file types This is managed by Windows, not Excel; it is not a bug

Your Pre-Embedding Checklist

Use this list before embedding a file to ensure the result works as expected:

  1. Check your version. Are you using the Excel desktop app? Local file embedding does not work in Excel for the web.
  2. Confirm the file type. PDFs, Word documents, images, and other Excel files all work with the Object tool.
  3. Decide on display. Select “Display as icon” for a more compact look. Leave it unchecked for a thumbnail preview.
  4. Choose embed or link. Need a self-contained file? Embed it. Need live updates? Use the “Link to file” option instead.
  5. Watch the file size. Embedding large files increases the workbook size noticeably. Link to them if size is a concern.

References & Sources