Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    saved workspace (xl2ksp3)

    Somebody showed me this trick.
    When I follow the instructions, involving opening 4 files arranged 'just so', the results are unsatisfactory in these two respects:
    1. The zoom settings for individual worksheets are not respected
    2. The 'freeze panes' instructions on each worksheet are lost
    When I close the files without saving and open each of them 'in the ordinary way' (from windows explorer, in my case), they remain well-behaved.
    Is it me, or excel, which is getting it wrong?
    Failed to find anything in the MS KB

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: saved workspace (xl2ksp3)

    The workspace concept was useful in Excel 4 or so, when a workbook only consisted of one worksheet. It's still available for compatibility purposes, but it hasn't really been updated, so it's pretty useless. You can create many worksheets within one workbook, and you can open a bunch of workbooks at once from Windows Explorer or from within Excel, so you don't really need a workspace any more.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: saved workspace (xl2ksp3)

    >>and you can open a bunch of workbooks at once from Windows Explorer or from within Excel, so you don't really need a workspace any more.
    Thanks, Hans, I'd come to the view that as it isn't reliable, it's not worth the bother.
    The only advantage would have been to handle the fact that the files I want to work with live, for good reasons, in different folders.
    But thnaks, as usual, for your time.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: saved workspace (xl2ksp3)

    You can create shortcuts for workbooks in another folder.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: saved workspace (xl2ksp3)

    Hadn't thought of that!
    Thanks!

Posting Permissions

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