How to Open a Linked File in Excel from a Cell Link

How-to basics · Updated November 20, 2026

To open a file linked from an Excel cell, follow the cell’s hyperlink: in Excel for Microsoft 365 on Windows, hold Ctrl and click the linked cell if Excel is set to require Ctrl-click. To create a file link, select a cell, choose Insert > Link, browse to the file, and select it. You’ll need access to the target file and a working path to its current location.

What You’ll Need

  • An Excel workbook that contains a hyperlink, or permission to add one.
  • The target file saved in a location you can access, such as a folder on your computer, a shared network drive, or a cloud storage location.
  • The correct file path or location. If the file is stored on a shared drive or in a cloud service, you may need to be signed in to the relevant account or connected to your organization’s network.

Step-by-Step

  1. Check that the cell contains a file hyperlink. Look for underlined or colored text, which often indicates a link. Hover over the cell to see whether Excel displays a path or link destination. If the cell looks like ordinary text, right-click it and look for Open Hyperlink or Edit Hyperlink. If those options are absent, it may not be a hyperlink yet. A cell that displays a value calculated from another workbook is a different kind of link; it does not necessarily open that workbook when clicked.
  2. Follow the link in Windows Excel. If the cell is a hyperlink, hold down Ctrl and click it. Excel commonly uses Ctrl-click to avoid opening links when you are selecting cells. If a security or confirmation message appears, check that the destination is the file you expect before choosing the option to continue. Excel may open the file in its associated application, such as another Excel window or a PDF reader.
  3. Try a regular click if Ctrl-click is not required. Some Excel settings or versions let you follow a link with a normal click. If a click only selects the cell, do not double-click repeatedly: double-clicking usually starts editing the cell rather than opening its destination. On Excel for Mac, try Command-click if a normal click selects the cell. You can also right-click the hyperlink and choose Open Hyperlink, if that command is available.
  4. Create a hyperlink if the cell is not linked. Select the cell where you want the link, or select existing text in the cell that should serve as its label. Choose Insert > Link on the ribbon, or press Ctrl+K on Windows. In the link dialog, choose Existing File or Web Page if that option is shown. Browse to the target file, select it, and confirm the selection. The dialog’s labels can vary slightly by Excel build.
  5. Set a clear label for the link. In the link dialog, enter or retain descriptive display text, such as “Open project plan” or “View invoice PDF.” This is easier to recognize than a long folder path. Select OK to add the link. The cell should now show the label as a hyperlink. The link points to a location; it does not embed a copy of the file in the workbook.
  6. Test the destination. Save the workbook, then follow the hyperlink using the click method that works in your Excel version. Confirm that the intended file opens, rather than a similarly named file or an old copy. If you created a link to a cloud or network location, test it while signed in and connected as the workbook’s intended users will be.
  7. Repair an existing link when the file has moved. Right-click the linked cell and choose Edit Hyperlink. Update the destination to the file’s new location, then select OK and test the link again. If you cannot tell which destination is stored, open the edit dialog and inspect the address or path before changing it. Avoid replacing a valid destination with a guessed path.
  8. Use a formula only if you want to create the link that way. With the target file at C:\Reports\Budget.xlsx and the formula entered in cell A2, use =HYPERLINK("C:\Reports\Budget.xlsx","Open budget"). The result is a clickable link displaying “Open budget.” The file must exist at that path, and the person opening the workbook must be able to access it. A formula-created link is still a hyperlink; it does not attach or copy the target file.

For a shared workbook, prefer a destination that all intended readers can reach. A path such as a personal Downloads folder may work only on your computer. A shared network path or an organization-approved cloud link is usually more appropriate for colleagues, provided their accounts have permission to open the file.

Common Mistakes

  • Clicking without the required key. On Windows, a regular click may select the cell rather than follow the link if Ctrl-click behavior is enabled. Use Ctrl-click, or check the relevant Excel setting.
  • Double-clicking to open the target. Double-clicking often puts the cell into edit mode. Use the appropriate click method or the right-click menu instead.
  • Linking to a local path that only works for you. A path such as C:\Users\YourName\Desktop\file.xlsx is specific to that computer and user. Other people may not have the same folder or file.
  • Moving or renaming the target after linking. A hyperlink generally keeps its saved destination. If the file moves, the old destination may no longer work, so edit the hyperlink or create a new one.
  • Confusing a hyperlink with a workbook reference. A formula that refers to another workbook can show a value without being a clickable file link. Clicking that value will not necessarily open the source workbook.
  • Trusting an unexpected destination. A link can point to an unfamiliar website or file. Inspect its destination before opening it, especially in a workbook received from someone else.

Tips

  • Use descriptive link text. “Open the signed contract” tells readers what to expect; a raw address or the word “here” does not. Keep the destination itself accurate even when the display text is short.
  • Choose a stable shared location. If several people need the file, store it in an approved shared folder or cloud location and confirm that each person has access. A shortcut to a local file is not a substitute for sharing the file.
  • Keep the workbook and target together when appropriate. For a set of files that will be moved as a unit, use a consistent folder structure and check links after moving the folder. Relative links may behave differently depending on how the link was created and where the workbook is opened, so test the finished setup.
  • Check the link before distributing the workbook. Open each important link from the saved copy, not just from the original workbook. Ask a colleague with the intended access level to verify shared links when practical.
  • Know where to inspect a link. Right-click a hyperlink and choose Edit Hyperlink to see or change its destination. If you only want to remove the click action but keep the displayed text, use the available remove-hyperlink command from the cell’s context menu.
  • Adjust Windows click behavior if needed. In Excel for Microsoft 365 on Windows, go to File > Options > Advanced. Under Editing options, check the setting labeled Use Ctrl + Click to follow hyperlink. Changing it affects how links behave in Excel, so consider whether you prefer easier link-opening or safer cell selection.

Troubleshooting

The cell selects but the file does not open: Try Ctrl-click on Windows or Command-click on Mac. If neither works, right-click the cell and look for Open Hyperlink. If that command is missing, the cell may contain plain text rather than a hyperlink. Create one using Insert > Link, or inspect the cell’s formula bar to see whether it contains a HYPERLINK formula.

Excel says it cannot open the specified file: Right-click the cell, select Edit Hyperlink, and check the destination for a typo, outdated folder name, or renamed file. Use the browse option to select the file at its current location. For a network path, connect to the required network or VPN first. For a cloud file, sign in and confirm that the file is still available to your account.

The link works on your computer but not for someone else: The destination may be a local path, or the other person may not have permission. Move or share the file through an approved common location, create a link to that shared destination, and make sure the recipient has access. Then send or save the updated workbook. Simply emailing the workbook does not automatically send the linked file.

A warning appears before the file opens: Excel or Windows may warn about links to external content or files. Verify the displayed destination and only proceed if you trust the source and expected the file. If your organization blocks a type of link, ask its IT administrator about the approved sharing method instead of weakening security settings.

The cell shows a value but has no Open Hyperlink command: It may contain an external workbook formula rather than a hyperlink. Select the cell and inspect the formula bar. In Microsoft 365, the Data > Workbook Links command may be available for managing links to other workbooks. Use that feature to inspect or update workbook references; add a separate hyperlink if you also need a cell that opens the source file.

The link opens the wrong file or an older copy: Edit the hyperlink and compare its full destination with the current file location. Similar file names in different folders can be misleading. Update the destination, save the workbook, close it, and test the saved version so you know the corrected link was retained.

Frequently Asked Questions

How do I open a linked file in Excel without Ctrl-click?
On Windows, review File > Options > Advanced and the Use Ctrl + Click to follow hyperlink setting. If you turn it off, a regular click may follow links, but it may also make selecting linked cells less convenient. You can also use the cell’s right-click menu.

Can I link a file stored on my computer?
Yes. Choose Insert > Link, browse to the file, and add it. A local file link is most reliable on the computer where that path exists. It may fail for other people or after the file is moved.

Can a cell open a PDF or another file type?
Yes. A hyperlink can point to many file types, not just Excel workbooks. The file opens in the application associated with that type, or Windows may ask which application to use. You still need permission to access the file.

Does linking a file embed it in the workbook?
No. A normal hyperlink stores a destination, not the file itself. If the target is moved, deleted, or unavailable to the person opening the workbook, the link may stop working. Share the target separately or use an approved shared location.

Why does clicking a linked cell show a number or text instead of opening a file?
The cell may be displaying a formula result or an external workbook reference, not a hyperlink. Inspect the formula bar and right-click the cell. If you need a clickable destination, insert a hyperlink separately or use a valid HYPERLINK formula.

Will the same click method work in Excel for the web?
Not always. Excel for the web opens links through the browser and may handle selection differently from the Windows desktop app. If the link is not followed with a click, use the browser’s available link command or open the workbook in the desktop app. Your browser and account must also be allowed to access the target file.

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.