open several workbooks at the same time
On 6 June, 16:02, Gord Dibben <gorddibbATshawDOTca wrote:
2003 version.
With the workbooks open. *FileSave Workspace.
To see the workbooks on the Taskbar....ToolsOptionsViewWindows in
Taskbar.
Gord
On Sat, 5 Jun 2010 10:23:22 -0700 (PDT), Johnnyboy5
wrote:
On 5 June, 18:05, Gord Dibben <gorddibbATshawDOTca wrote:
See help on saving a set of files as a workspace.
Basics are.............open your 3 or 4 workbooks.
ViewSave Workspace.
Default name is resume...........extension .xlw
Give your workspace whatever name you like and save.
I will use *mywkspace
Now close all workbooks.
Open mywkspace.xlw *and all books will open.
Gord Dibben *MS Excel MVP
On Sat, 5 Jun 2010 09:47:35 -0700 (PDT), Johnnyboy5
wrote:
I would like to repeatly open the same workbooks at the same time just
by selecting just one book and the other three or four will open with
it.
thanks *everyone
Thanks kind of works, *but I would like each workbook (4 of them) to
appear as tabs at the bottom)
oh I am using Excel 2003
Thanks
John
|