Workbooks

Tips, Tricks, and Answers

The following articles are available for the 'Workbooks' topic. Click the article's title (shown in bold) to see the associated article.

Changing a Link's Source
If your worksheet is linked to data in other worksheets, you may need to change the link from time to time. Here's how to accomplish the task.

Checking Workbook Statistics
Excel keeps track of a range of stats about each workbook you use. If you want to take a look at those stats, it's easy; just display the Properties dialog box for the workbook.

Displaying Workbooks on the Taskbar
By default Excel displays each open workbook as a separate task on the Taskbar. If you prefer, you can configure Excel so that there is only a single task button representing all open workbooks.

Duplicating a Workbook
Want to make a duplicate of your workbook so that your work doesn't mess up the original? The Open dialog box includes a command that will do the duplication for you.

Opening a New Workbook Window
If you need to look at different parts of the same worksheet at the same time, the answer is to create windows for your data. It is easy to do, as described in this tip.

More Information

The following are additional topics related to the subject of 'Workbooks'. A bracketed number after the topic indicates how many articles are related to that subject.