Sometimes you may open several workbooks and work with a number of the same workbooks at a time. You can open this group of files with Microsoft Excel 2007 simultaneously. But you have to define them as part of a workspace, and save them in a single Excel 2007 file.
To do this, follow below steps:
1- **** On the View tab and then in the Window group **** Save Workspace. The Save Workspace dialog box appears.
2- In the File name field, type your work name and then **** Save.
3- At the top-left of window, **** the Microsoft Office logo and then **** Close to close workbooks.
4- **** the Microsoft Office logo and then **** Open. The Open dialog box appears.
5- Open saved Workspace. Microsoft Excel 2007 opens all workbooks simultaneously.