Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Workspace function (Excel 2000)

    We currently open a number of spread sheets for our bookkeeping function on a daily basis. I just recently discovered the Save Workspace function (so I'm a little slow). The problem that I am having is when I open worksheets with the Workspace option, that have been formatted to have the gridlines and row and column heading turned off , are being reformatted to have those options turned on. I can open the worksheets by any other means - shortcut, quick launch bar, from within Excel, and the re-formatting does not occur. Is there something that I am doing incorrectly or not doing that I am supposed to be doing? Thanks for any help.

    shihalud

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workspace function (Excel 2000)

    Alas, I see the same behaviour. Clearly a bug in this workspace option (which I've never used).

    I guess your only workaround is to use a macro that loads all the workbooks you need (which also gives you control over the order in which they are loaded).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workspace function (Excel 2000)

    Thanks for the info, I'll use macro as recommended.

    shihalud

Posting Permissions

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