O'Reilly logo

Master Visually®: Excel® 2007 by Elaine Marmel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 26. Linking and Consolidating Worksheets

Link Worksheets by Pointing

You can link the information stored in one workbook to another workbook to ensure that you have up-to-date information at all times. Suppose that your company keeps daily sales records in a workbook that is updated each day by another employee. Your job is to summarize the daily sales information so that you can then produce a variety of charts that show sales trends over time. You need the daily sales information to do your job.

Yes, you could open the other employee's workbook and copy the information into your own workbook. However, if you create a workbook that contains link formulas — also called external reference formulas — to the daily sales workbook, your workbook ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required