Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jun 2009
    Location
    India
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a set of files, using information from each other.
    I need to open all files together, every time, to keep the links updated.
    Is there any way to open all those, with a single attempt.

  2. #2
    3 Star Lounger
    Join Date
    May 2008
    Location
    India
    Posts
    306
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='Budhrani' post='785714' date='22-Jul-2009 11:12']I have a set of files, using information from each other.
    I need to open all files together, every time, to keep the links updated.
    Is there any way to open all those, with a single attempt.[/quote]
    If all files are in same folder, It can easily be done through open menu. Select desired files holding Ctrl key & hit open tab. Else you need a macro to perform the task.

    [attachment=84798:untitled.JPG]
    Attached Images Attached Images
    Regards
    Prasad

  3. #3
    New Lounger
    Join Date
    Jun 2009
    Location
    India
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks prasad.
    But this can be done if all files resids in same folder.

    Actuay my problem is, files are at different paths.

    Macro can serve my purpose. But I am seeking the way to bind all files together to make a sort of packet.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Open the set of workbooks.
    If you don't view the workbooks maximized, arrange their windows the way you want.
    Now select File | Save Workspace...
    Specify a name (the default is resume.xlw), and click Save.
    The workspace file (.xlw) does *not* contain the workbooks themselves, only information about which workbooks were opened and how their windows were arranged.
    The workspace file will be listed in the File | Open dialog, and also in the list of recently used files.
    Opening the workspace file will open the workbooks that were open when you created the workspace file.

    If you have multiple sets of workbooks, you can create multiple workspace files.

  5. #5
    New Lounger
    Join Date
    Jun 2009
    Location
    India
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Hans.
    This is exactly, I was looking for.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •