Microsoft® Office Excel® 2007 Plain & Simple

Creating Formulas that Reference Cells in Other Workbooks

One of the strengths of Excel is that you aren’t limited to using cells from the current workbook in your formulas. If you want, you can use data from any other workbook in your calculations. For example, you might have a workbook in which you track monthly advertising sales for your newsletter. If you want to create a new workbook to summarize all income and expenses for your publication, you can do so. By letting you create formulas that reference cells from more than one workbook, Excel makes it easy for you to organize your workbooks so that each workbook holds data about a specific subject. Not only can you find the data easily, you can reference it anywhere else.

After you’ve created ...