Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Scenarios
I created a file which I then sent to two people to create best and worst
case scenarios for their input cells. All scenario names are unique €“ weve added our initials after the Best Case etc. I have merged the scenarios from the other two people into my file and created a Scenario Pivot Table Report. I am using the pivot table report because it enables me to see the combined impact of the different scenarios, which it does. However, the page fields are showing only the options of All and MyName. I changed the Author field in the file properties to indicate the other peoples names before I sent it to them but this seems to have no effect. How can I control the name which appears in the page field drop down? I am using 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Scenarios
The Scenario should take the name that's in ToolsOptions, General tab,
in the User box, when the Scenario is created. Mary Ann wrote: I created a file which I then sent to two people to create best and worst case scenarios for their input cells. All scenario names are unique €“ weve added our initials after the Best Case etc. I have merged the scenarios from the other two people into my file and created a Scenario Pivot Table Report. I am using the pivot table report because it enables me to see the combined impact of the different scenarios, which it does. However, the page fields are showing only the options of All and MyName. I changed the Author field in the file properties to indicate the other peoples names before I sent it to them but this seems to have no effect. How can I control the name which appears in the page field drop down? I am using 2003. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Scenarios
Ah!...That explains it. Thank you.
"Debra Dalgleish" wrote: The Scenario should take the name that's in ToolsOptions, General tab, in the User box, when the Scenario is created. Mary Ann wrote: I created a file which I then sent to two people to create best and worst case scenarios for their input cells. All scenario names are unique €“ weve added our initials after the Best Case etc. I have merged the scenarios from the other two people into my file and created a Scenario Pivot Table Report. I am using the pivot table report because it enables me to see the combined impact of the different scenarios, which it does. However, the page fields are showing only the options of All and MyName. I changed the Author field in the file properties to indicate the other peoples names before I sent it to them but this seems to have no effect. How can I control the name which appears in the page field drop down? I am using 2003. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Scenarios and Scenario Manager | Excel Worksheet Functions | |||
When merging information not merging correctly | Excel Worksheet Functions | |||
Mail Merging | Excel Discussion (Misc queries) | |||
Scenarios tutorial | Excel Worksheet Functions | |||
Using a formulae within scenarios | Excel Discussion (Misc queries) |