Is it possible to link excel sheets

For example, the following formula adds the cells CC25 from the workbook named Budget. Note: If the name of the other worksheet or workbook contains spaces or non-alphabetical characters, you must enclose the name or the path within single quotation marks as in the example above.

Excel will automatically add these for you when you select the source range. Formulas that link to a defined name in another workbook use the workbook name followed by an exclamation point! For example, the following formula adds the cells in the range named Sales from the workbook named Budget. A1:A10 , and have a current version of Microsoft , then you can simply press ENTER to confirm the formula as a dynamic array formula. Open the workbook that will contain the external reference the destination workbook, also called the formula workbook and the workbook that contains the data that you want to link to the source workbook, also called the data workbook.

Switch to the destination workbook, and then click the worksheet where you want the linked data to be placed. Excel will return the data you copied from the source workbook.

If you change it, it will automatically change in the destination workbook when you refresh your browser window. You can always ask an expert in the Excel Tech Community or get support in the Answers community. Define and use names in formulas.

Find links external references in a workbook. Create an external reference between cells in different workbooks. Select the cell or cells where you want to create the external reference. Select the cell or cells that you want to link to and press Enter. Create an external reference to a defined name in another workbook. Define a name that contains an external reference to cells in another workbook.

Open the destination workbook and the source workbook. Select the cell or range of cells that you want to link, and click OK. CC25 When the source is not open, the external reference includes the entire path. CC25 Note: If the name of the other worksheet or workbook contains spaces or non-alphabetical characters, you must enclose the name or the path within single quotation marks as in the example above. Switch to the worksheet that contains the cells that you want to link to.

If the source and destination worksheets are in the same workbook, moving the workbook to a different folder or even a different computer should not be a problem.

But if either worksheet is moved to a different folder, the link will break! Also, companies that store worksheets on network servers have additional factors to consider that are outside the scope of this tutorial. To ensure that the external cell reference automatically updates when the source is updated, follow the steps below for your version of Excel:. Method One : On the Calculation section of the Excel ribbon, click the small arrow by Calculation Options and select Automatic as shown.

On the left, click Formulas , and ensure Automatically is checked under "Calculation Options. When you have formulas in spreadsheets, it is important to protect them from accidental deletion. We recommend locking the cells and protecting the worksheet.

When you open the destination spreadsheet, you may get a security warning that "Automatic update of links has been disabled" as shown in the image below. To bypass this warning, press the Options button in the upper right corner. Microsoft will display a Security Alert similar to the image below, warning that if you enable automatic update of links, your computer may no longer be secure.

Assuming there actually is no risk, and to allow the link process to proceed, click the radio button by "Enable this content" and click OK. If you do not want to go through this process each time you open a destination worksheet, disable the alert by following these steps:.

As an Amazon affiliate partner we may earn from qualifying purchases. See our disclosure policy to learn more. Download Article Explore this Article Steps. Related Articles.

Article Summary. Open a Microsoft Excel workbook. The Excel icon looks like a green-and-white "X" icon. Click your destination sheet from the sheet tabs. You will see a list of all your worksheets at the bottom of Excel. Click on the sheet you want to link to another worksheet. Click an empty cell in your destination sheet. This will be your destination cell. When you link it to another sheet, the data in this cell will be automatically synchronized and updated whenever the data in your source cell changes.

It will start a formula in your destination cell. Click your source sheet from the sheet tabs. Find the sheet where you want to pull data from, and click on the tab to open the worksheet.

Check the formula bar. The formula bar shows the value of your destination cell at the top of your workbook. When you switch to your source sheet, it should show the name of your current worksheet, following an equals sign, and followed by an exclamation mark. Alternatively, you can manually write this formula in the formula bar. Click a cell in your source sheet. This will be your source cell. It could be an empty cell, or a cell with some data in it. When you link sheets, your destination cell will be automatically updated with the data in your source cell.

This will finalize the formula, and switch back to your destination sheet. Your destination cell is now linked to your source cell, and dynamically pulls data from it.