excel Referencing other sheets or workbooks

When a formula refers to other cells, the references don’t need to be on the same sheet as the
formula. To refer to a cell in a different worksheet, precede the cell reference with the sheet
name followed by an exclamation point. Here’s an example of a formula that uses a cell reference
in a different worksheet (Sheet2):
=Sheet2!A1+1
You can also create link formulas that refer to a cell in a different workbook. To do so, precede
the cell reference with the workbook name (in square brackets), the worksheet name, and an
exclamation point. Here’s an example:
=[Budget.xlsx]Sheet1!A1
If the workbook name in the reference includes one or more spaces, you must enclose it (and the
sheet name) in single quotation marks. For example:
=’[Budget For 2010.xlsx]Sheet1’!A1
If the linked workbook is closed, you must add the complete path to the workbook reference.
Here’s an example:
=’C:\Budgeting\Excel Files\[Budget For 2010.xlsx]Sheet1’!A1
Although you can enter link formulas directly, you can also create the reference by using normal
pointing methods. To do so, the source file must be open. When you do so, Excel creates absolute cell references. If you plan to copy the formula to other cells, make the references relative.