Results 1 to 3 of 3

Thread: Value set

  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The other day I was typing in Excel and I hit some combination of keys and the save window popped up and I was prompted to save a 'value set'. I was in a hurry and just canceled it but later I was wondering what a value set is. I currently use a SS to generate estimates for jobs and I have to save the entire SS in order to reconstruct that estimate again since I use different values for each estimate. It would be cool if this value set was a way to save and reload a set of values into a SS.

    Despite looking, I can't find any information about this... anyone in the Lounge know anything about this?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Maybe you bumped into the scenario manager? (In the tools menu)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You are probably right. Thanks for the lead - I looked up scenario manager and that may meet my need.

    [quote name='pieterse' post='793348' date='14-Sep-2009 23:41']Maybe you bumped into the scenario manager? (In the tools menu)[/quote]

Posting Permissions

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