Calculation Issues

How to Link Excel Data to Another Workbook for Automatic Price Updates

Muhammad Talha Sep 28, 2026 870 views

Question details

The user wants to establish a live connection between two Excel workbooks so that a price column in the destination file automatically updates based on data from a source file.

How to Link Excel Data to Another Workbook for Automatic Price Updates

Product: Excel
Device & OS: not provided
Scenario: Automating price list updates by referencing formulas, cells, or tables located in a separate, external Excel workbook.
Observed behavior: Needs to create, update, and manage external link formulas using correct file paths and cell references without breaking the connection.

Before you start

Before creating links, ensure both your source and destination workbooks are saved in a stable, permanent folder on your computer to prevent broken link errors if files are moved.

Solution 1Recommended

Create an External Reference Link Between Workbooks

The most reliable method to link data across workbooks is by keeping both files open and pointing directly to the exact source cell to generate the file path automatically.

By selecting the source cell directly while both files are open, Excel automatically formats the external reference formula with the correct workbook name, worksheet name, and cell reference.

When the source workbook is later closed, Excel automatically updates the formula to include the full file path to the source document.

Open Both Workbooks

Open both the source workbook containing your original prices and the destination workbook where you want the automated updates to appear.

Initiate the Formula

In the destination workbook, click on the specific price cell you wish to update automatically and type an equals sign (=).

Select the Source Cell

Switch your view to the source workbook window, click on the cell containing the target price data, and press the Enter key.

Manage the Link

Save both workbooks. To manage this connection later, go to the Data tab on the ribbon and click Edit Links to update, change, or break the source connection.

Security Prompts for External Links: When opening a workbook containing external links, the software may prompt you to 'Enable Content' or 'Update Links'. Always allow the update if you trust the source document.

Manage Spreadsheet Links with WPS Office

Link Data Across Workbooks Seamlessly in WPS Spreadsheet

WPS Office provides a highly compatible and intuitive Spreadsheet tool that allows you to easily link data between multiple workbooks, ensuring your pricing tables and financial reports remain perfectly synced and up to date.

1. Open your files: Launch WPS Spreadsheet and open both your source data workbook and your destination workbook.
2. Create the link: Select the target cell in your destination workbook, type '=', switch to the source workbook tab, and click the source data cell.
3. Manage your links: Press Enter to finalize the formula. You can review and control all connected files by navigating to the Data tab and selecting Edit Links.

Fully compatible with Microsoft Excel formats, including .xlsx and .xls.Easily manage, update, or break external links via the Data tab interface.Lightweight application that opens multiple large workbooks quickly without lagging.Free to download and use for your essential daily office tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my external Excel links show a #REF! error?

This usually happens if the source workbook has been moved, renamed, or deleted. To resolve this, navigate to the Data tab, click Edit Links, and select 'Change Source' to point to the new file location.

How do I update prices if the source workbook is currently closed?

When you open the destination workbook, you will typically receive a security warning prompting you to update external links. Clicking 'Update' will automatically pull the latest price data from the closed source workbook in the background.

How can I remove an external link but keep the current price value?

If you want to freeze the data, go to the Data tab, click Edit Links, select the specific link from the list, and click 'Break Link'. This action permanently replaces the external formulas with the current static values.

Can I link an entire table or column instead of just a single cell?

Yes. After typing the equals sign (=) in the destination workbook, you can highlight an entire column or range in the source workbook. You can also directly type an external structured reference if the source data is formatted as a named table.

Excel & Data Problems