Excel automatically updating workbooks


Consider a Sales Manager who has a detailed spreadsheet for each salesperson, but would like a summary sheet to compare salespersons' performance and create grand totals. In the example below, using Method One, we click in cell B6 in the source worksheet and click Copy.

excel automatically updating workbooks-74excel automatically updating workbooks-80

This is a great productivity tool and can reduce the need for additional worksheets!

In this tutorial, you will learn how to link worksheet data in all versions of Excel.

You will also learn hints and tips on how to work with this cool feature. PS: The terms In Excel, a link is a formula that dynamically pulls in data from a cell in another worksheet.

This saves time, reduces errors, and improves data integrity.

For example, a company's prices can be stored in a 'Master Price List' worksheet, and others needing pricing data can link to that worksheet.

This is not prohibited, but can make both worksheets very slow to open and update, so Microsoft recommends against it.

You must have an account to comment. Please register or login here!