Linking Worksheets and Workbooks
Auto Beauty Business Culture Dieting DIY Events Fashion Finance Food Freelancing Gardening Health Hobbies Home Internet Jobs Law Local Media Men's Health Mobile Nutrition Parenting Pets Pregnancy Products Psychology Real Estate Relationships Science Seniors Sports Technology Travel Wellness Women's Health

Linking Worksheets and Workbooks

Linking Worksheets and Workbooks Linking worksheets and workbooks enable cells in one worksheet to refer to data stored in another worksheet. Thus, data spread across different worksheets and workbooks can be consolidated. You can't link one cell, a range of cells or a named constant to data in other sheets. The workbook containing the source data is known as the source workbook. The workbook that uses the linked data is known as the target workbook. The source workbook need not be open when you are working with the target workbook.

Linking Worksheets and Workbooks

Linking worksheets and workbooks enable cells in one worksheet to refer to data stored in another worksheet. Thus, data spread across different worksheets and workbooks can be consolidated. You can't link one cell, a range of cells or a named constant to data in other sheets. The workbook containing the source data is known as the source workbook. The workbook that uses the linked data is known as the target workbook. The source workbook need not be open when you are working with the target workbook. You can still retrieve the data from the source workbook that is saved on the disk. This allows you to maintain smaller worksheets and combine the data as and when required. Some of the advantages are:

Systems composed of small, special purpose workbooks are flexible and can be updated easily. You can redesign the data structure without rebuilding the entire workbook. Such a modular approach is very useful when you are developing a complex application.

Smaller workbooks occupy less memory and perform calculations faster than single, large workbooks.

Data can be shared across different users. Each user can work on a particular module and finally, all the workbooks can be integrated to build the entire system.

Naming Worksheets

One of the features in Excel that you might need to use while linking cells and worksheets is the facility to name a worksheet. When a workbook is created, the sheets are named Sheet 1, Sheet 2 and so on. You can change the names of the worksheets to assign more meaningful names that indicate the content of the worksheet.

The steps to rename a sheet are:

• Double-click on the sheet tab that you want to name.

• Type the name that you want to assign to the worksheet in the Name text box.

• Worksheet names can be up to 31 characters and cannot include a ?,',/, \, and :

Consider a situation where you have the total number of passengers that are expected to travel by Jet Airways during the months January...December, you have calculated the total number of passengers for the year.

Now, you need to use this data for analysis in another worksheet. If you copy the value from one worksheet to another, you will have to update the value every time you change the number of passengers. However, if you create a link to the worksheet storing the total passengers value, the value is updated every time you change a value.

Need an answer?
Get insightful answers from community-recommended
experts
in Software on Knoji.
Would you recommend this author as an expert in Software?
You have 0 recommendations remaining to grant today.
Comments (0)
ARTICLE DETAILS
RELATED ARTICLES
RELATED CATEGORIES
ARTICLE KEYWORDS