Managing Multiple Workbooks
This part of the chapter describes how to protect workbooks, how to use more than one workbook at a time, and how and why to split your view of a workbook into multiple windows. Generally when you start Microsoft Office Excel 2007, a blank workbook appears with the provisional title Book1. The only exceptions occur when you start Office Excel 2007 by opening an existing workbook or when you have one or more Excel files stored in the XLStart folder so that they open automatically.
If you start Excel with Book1 visible and then open an existing Excel file, Book1 disappears unless you have edited it. You can open as many workbooks as you like until your computer runs out of memory.
For more about working with multiple ...