Linking data between spreadsheets in Excel 2013, 2010 or 2007 ties cells on separate pages together, automatically updating a target cell whenever the source cell changes. By linking instead of copying data, you can leave your messy calculations on one sheet and display the result cleanly on another. Excel can also link data between entirely separate workbook files, as long as both files are on the same computer or network.
Select the cell or range of cells that currently contain the source data and copy it by pressing "Ctrl-C." If you need to link data from multiple non-consecutive cells, perform all steps on each cell separately.
Video of the Day
Switch to the sheet where you want to display the data. If the sheet is in a separate workbook, open it from the File menu or by double-clicking it in Windows, but also leave the original workbook open in Excel until you finish the entire process.
Right-click the target cell for the link. When linking a range of cells, right-click the top-left-most cell. Choose "Paste Link" from the Paste Options to create the link.
Click any linked cell to see or modify the link's source in the formula bar. The formula for links begins with an equals sign, and separates the spreadsheet's name and cell with an exclamation point. For example, the formula "=Sheet1!D2" links to cell D2 on Sheet1. When linking to another workbook, the file name appears first in square brackets, such as "=[Book2.xlsx]Sheet1!D2."