Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh scenario information in a pivot table
Good morning. I am hoping somebody knows the answer to this. I have three
scenarios that I need run for a complicated workbook I have set up. When I run the scenarios I have them put into a pivot table. The problem is that if somebody needs to change information (in cells other than those labeled as "changing cells" in the scenario) after the scenarios are run the "result cells" do not change accordingly. Do they need to re-run the scenarios every time if information changes, or is there a way to refresh the information in the pivot table for each scenario? I am new to using pivot tables. The refresh button on my toolbar is grayed out for my pivot table. Hopefully I am explaining this correctly. Any help would be greatly appreciated. Thanks! Jaclyn |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh scenario information in a pivot table
You can't refresh the pivot table that's created by the Scenario Manager. If
the information changes, you can create a new copy of the pivot table. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "Fin Analyst" wrote in message ... Good morning. I am hoping somebody knows the answer to this. I have three scenarios that I need run for a complicated workbook I have set up. When I run the scenarios I have them put into a pivot table. The problem is that if somebody needs to change information (in cells other than those labeled as "changing cells" in the scenario) after the scenarios are run the "result cells" do not change accordingly. Do they need to re-run the scenarios every time if information changes, or is there a way to refresh the information in the pivot table for each scenario? I am new to using pivot tables. The refresh button on my toolbar is grayed out for my pivot table. Hopefully I am explaining this correctly. Any help would be greatly appreciated. Thanks! Jaclyn |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh scenario information in a pivot table
That's what I was afraid of. Glad somebody could verify that for me. Thanks
for your help! Jaclyn "Debra Dalgleish" wrote: You can't refresh the pivot table that's created by the Scenario Manager. If the information changes, you can create a new copy of the pivot table. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "Fin Analyst" wrote in message ... Good morning. I am hoping somebody knows the answer to this. I have three scenarios that I need run for a complicated workbook I have set up. When I run the scenarios I have them put into a pivot table. The problem is that if somebody needs to change information (in cells other than those labeled as "changing cells" in the scenario) after the scenarios are run the "result cells" do not change accordingly. Do they need to re-run the scenarios every time if information changes, or is there a way to refresh the information in the pivot table for each scenario? I am new to using pivot tables. The refresh button on my toolbar is grayed out for my pivot table. Hopefully I am explaining this correctly. Any help would be greatly appreciated. Thanks! Jaclyn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get information from a Pivot TAble without retyping? | Excel Discussion (Misc queries) | |||
auto refresh of pivot table | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Pivot Table Data Refresh | Excel Discussion (Misc queries) |