Entering a Formula That Referencing Data from Multiple Workbooks

• =[Workbook Name]Sheet Reference!Cell Range

• To create a formula in one workbook to reference cell B21 on the Summary worksheet of the Sales.xls workbook

=[Sales.xls]Summary!B21

• If the workbook name or sheet name contains one or more spaces, enclose the entire workbook name and sheet name reference in single quotation marks.

='[US Sales.xls]Summary'!B21

• If one of the workbooks is in different folder,

='C:\My Documents\Domestic Sales\[US Sales.xls]Summary'!B21