Grouping Multiple Data Lists
When you work with Excel for a while, you’ll find that you often work with a number of the same workbooks at a time. For instance, Catherine Turner, the owner of The Garden Company, might always pull up a yearly sales summary workbook and the sales figures for product categories offered by The Garden Company. She can open the workbooks together through the Open dialog box, but she can also group the files so that she has the option of opening them all simultaneously.
If you want to open a set of files simultaneously, you can define them as part of a workspace, which uses a single Excel file name to reference several workbooks ...
Get Microsoft® Office Excel® 2003 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
