In Excel, direct access usually means opening or connecting to the source itself; a link points from one workbook to another or lets a reader navigate to a location. For changing source data, use a connection or query when you need controlled imports and refreshes, and a workbook link when you need a formula to refer to particular cells; a hyperlink is only for navigation.
What direct access and a link mean in Excel
“Direct access” is not one specific Excel command, so its meaning depends on the task. It can mean opening a workbook stored on your computer or a shared drive, connecting Excel to a database, or importing a file’s data with Power Query. In each case, Excel reaches the source rather than relying only on a reference typed into a cell. Access does not necessarily mean that the data stays live: opening a file shows its current saved contents, while an imported query usually needs to be refreshed to retrieve later changes.
A workbook link usually means a formula in one workbook refers to a cell or range in another workbook. For example, a summary workbook might show a value from a monthly sales workbook. Excel can update the displayed result when the source is available, but the destination workbook is still a separate file. A hyperlink is different: it opens a file, web page, email address, or place in a workbook when clicked. It does not pull the destination’s cell value into the current cell.
That distinction resolves a common misunderstanding: clicking a link to a workbook is not the same as linking cells from that workbook. If you want a reader to open the source, use a hyperlink. If you want a cell to show a source value, use a workbook formula link or an appropriate data connection.
How a link to another workbook works
An external workbook formula stores a reference to a source workbook, worksheet, and cell. With a destination workbook open, and a source workbook named Sales.xlsx open with a worksheet named January and a value in B2, a destination cell can contain ='[Sales.xlsx]January'!B2. Excel displays the referenced value. In practice, selecting the source cell while building the formula is less error-prone than typing the reference manually.
When the source workbook is closed, Excel may include its file path in the reference. That path matters: if the source file is moved, renamed, or no longer available at the expected location, the link may stop updating. A link to a workbook on a shared drive or in a cloud folder can also depend on the user’s access permissions and whether the file is reachable.
Workbook links are useful for modest, straightforward dependencies, such as a dashboard that pulls a few totals from a maintained budget file. They can become harder to manage when many workbooks link to one another, when source files are frequently renamed, or when users keep different copies in different folders. A formula can continue showing its last saved result even when Excel cannot currently retrieve a fresh value, so a plausible-looking number is not proof that the source has updated.
What a direct connection or import does
For a repeatable import, Excel for Microsoft 365 on Windows includes Power Query. Use Data > Get Data to choose a source, such as a workbook, text file, or database. For another Excel file, the route is commonly Data > Get Data > From File > From Excel Workbook. You can select the relevant table or sheet, transform columns or filter rows, and load the result into a worksheet or the Data Model.
A query can be refreshed to retrieve changes from its source. Refreshing is not the same as continuously reading every edit as it happens; the timing depends on the connection and refresh settings. A query may also be configured as connection-only or loaded to a destination. This makes it suitable for bringing in a larger, structured table and applying repeatable cleanup steps, rather than creating a separate external formula for every result.
Some Excel connections, such as certain database or analytical-model connections, can support interactive or live-style reporting. The exact behavior depends on the source and connection type. Do not assume that every option under Get Data is live, or that a query refresh will work for every user: they may need network access, credentials, a compatible driver, and permission to reach the source.
Which option should you choose?
Choose based on what the workbook needs to do, not simply on which method sounds more direct. These are practical starting points:
- Open or edit the source file itself: access the workbook directly when you need to work with its contents as the source of truth.
- Display a few values from another workbook: use external formula links when the source and destination are stable and the cell-level dependency is easy to understand.
- Combine, clean, or periodically reload rows of data: use Power Query when you want a repeatable import and refresh process.
- Let someone open a source file or jump to a location: add a hyperlink; it is for navigation, not for importing a value.
- Share a report with people who may not have the source file: consider including the required data in the report, subject to your organization’s access and privacy rules, rather than assuming external references will resolve for everyone.
For example, suppose a department’s dashboard needs the latest total from a small, stable monthly workbook. A cell link may be simple and transparent. If the dashboard needs thousands of transaction rows from several monthly files, with consistent column cleanup and a repeatable refresh, Power Query is usually a better fit. If colleagues only need to find the monthly workbook, provide a hyperlink instead.
Updates, paths, and sharing
Excel may ask whether to update workbook links when a destination file opens. Whether it can refresh them depends on settings, access, and the source’s location. If you trust the source and need current values, verify that the update succeeds rather than dismissing a prompt without checking. In Microsoft 365 for Windows, linked-workbook controls are available from Data > Workbook Links when Excel detects workbook links. The interface can differ in older Excel releases, where the command may be labeled Edit Links.
Cloud storage introduces another practical consideration. A file shared through OneDrive or SharePoint can be opened by multiple authorized users, but a link still depends on those users having permission to the source and on the reference being usable in their environment. A path that works on one person’s computer may point to a folder that does not exist for a colleague. Test a shared workbook with an account that represents its intended audience.
When a workbook is moved, use Excel’s link-management controls to inspect or change broken references where available. Avoid casually renaming or relocating source files that many reports depend on. For recurring team workflows, agree on a stable folder or managed cloud location, document who owns the source, and decide who is responsible for refreshing and checking the output.
Common problems and how to diagnose them
A broken or stale result does not always mean the formula itself is wrong. Check the source path, file name, worksheet name, user permissions, and whether the source file is available. Also check whether Excel is displaying an old saved value because the link could not be updated. If a value is unexpected, open the source workbook and compare the referenced cell directly.
- The link cannot find the source: confirm the file was not moved or renamed, and check that the current user can access its folder.
- The displayed value seems out of date: review the update prompt or Workbook Links controls, then verify the result against the source.
- A query fails for a colleague: check their source permissions, credentials, network access, and any required database drivers.
- A hyperlink opens a file but a cell stays blank: that is expected; a hyperlink navigates, while a formula or query retrieves data.
- The workbook is slow or difficult to maintain: review how many external references it contains and whether a query or a single consolidated source would be clearer.
Do not treat a successful refresh as a guarantee that the imported information is correct. A query can refresh successfully while the source itself contains missing, duplicated, or incorrectly labeled records. Validate important totals and fields after changing the source or transformation steps.
Safety and maintenance considerations
External links and data connections can expose information or retrieve content from a location you do not control. Update only sources you recognize and are authorized to use. Excel may display security warnings or ask whether to enable connections; follow your organization’s policies rather than enabling a connection simply to remove a prompt. A link can also reveal the name or structure of a source file to people who receive the destination workbook.
For a workbook that will be circulated, decide whether recipients need a live dependency or just a point-in-time result. A static copy can be easier to distribute, but it will not update from the original source. A linked or connected version can stay refreshable, but recipients must have the right access and understand that figures can change when refreshed. Label the reporting date or refresh status when that context matters.
Frequently Asked Questions
Does a link in Excel update automatically?
A formula link may be updated when Excel can reach the source and link updates are allowed, but it is not safe to assume every change appears immediately. Check the workbook’s link status and compare important values with the source.
Is a hyperlink the same as an external workbook link?
No. A hyperlink opens a destination when clicked. An external workbook formula refers to a source cell and displays its value in the current workbook. Use the one that matches whether you need navigation or data.
Can I use a workbook link if the source file is closed?
Yes, Excel can store references to a closed workbook, often including its file path. The source still needs to be reachable for a fresh update, and a moved or renamed file can break the reference.
Should I use Power Query instead of formulas?
Use Power Query when you need repeatable importing, combining, or cleaning of structured data. Use formulas when you need a small number of clear cell-level references. The best choice depends on the source, the update process, and who must maintain the workbook.
Why does Excel show old linked data?
The source may be unavailable, the link may not have refreshed, or Excel may be showing a previously saved result. Check the source location and access, then inspect the workbook-link status and verify the relevant source cells.
Related
- Contacts List Template Excel: Build a Useful Workbook
- Contact List Excel Template: Free Options and Setup
- Contact List Format in Excel: Columns, Setup, and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Invoice Bill Format: Build a Useful TemplateAn Excel invoice bill format is a worksheet that records seller and customer details, invoice dates and numbers,…
- Excel to PowerPoint Link: How to Keep Slides UpdatedTo create an Excel-to-PowerPoint link in Microsoft 365 for Windows, copy the cells or chart in Excel, then…
- CSV File Too Large for Excel? Limits and FixesYes—a CSV file can be too large for Excel to display in a worksheet, even though the file…
- Excel Dependent Drop-Down Lists in Microsoft 365Yes. In Excel for Microsoft 365, you can make a dependent drop-down list by using Data Validation with…
- Excel: Copy an Entire Worksheet to a New Workbook SafelyTo copy an entire worksheet into a new workbook in Excel for Microsoft 365 on Windows, right-click the…
- Excel How to Paste in Merged Cells Without ErrorsTo paste into merged cells in Excel, make sure the copied range and the destination have the same…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.