Multi-book desktop shortcut – Open Workbooks Simultaneously

Posted on | March 21, 2011 | 1 Comment

Say, if you are preparing annual report say, AR.xlsx and there are four quarterly report files named Q1, Q2, Q3 and Q4 that you need to open and work with all these five files simultaneously.

To do so, try to open them once from their individual locations one by one wherever they are saved.  Then, click View->Window->Arrange All-> and choose TILED to make sure that all the five files are opened in the same window. (If not, then close another instant of Excel application and try opening the same file inside your first application window).

Now, just by clicking “Save Workspace” in the same View->Window group, you will be prompted to save the group of files as a Workspace with the extension .xlw (w stands for workspace).

You can now attempt closing all the files and open the workspace file (from wherever you saved it). That is it! It just opens all five files in no time and in the same way as you arranged them before saving workspace.  Since it is like a desktop shortcut, the workspaces do not take a copy/paste of the file to occupy more space but just the file name and path for reference.

Comments

One Response to “Multi-book desktop shortcut – Open Workbooks Simultaneously”

  1. Shreekanth Murali
    December 29th, 2011 @ 7:42 am

    Nice Blog with lot of new and useful information.Do you have an option to follow your blog?
    I have a blog for general scripting since in past i was working closely with exchange and AD, I started off the blog with basic AD scripting with an idea of expanding further with all other useful scripts as well. However new job responsibilities kept me busy. Now i am just planing to continue it with some code snippets for qucik reference and usage.
    msofficegurus is a wonderful blog among many that i have read so far. i have added this blog to my FAV list.

    You can take a look at (though the interface dosent look great :P)

    http://scriptingiseasy.blogspot.com/

Leave a Reply