software

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
quot;changing cellsquot; in the scenario) after the scenarios are run the quot;result
cellsquot; 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

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 amp; Book List
www.contextures.com/tiptech.html

quot;Fin Analystquot; gt; wrote in message
...
gt; Good morning. I am hoping somebody knows the answer to this. I have
three
gt; scenarios that I need run for a complicated workbook I have set up. When
I
gt; run the scenarios I have them put into a pivot table. The problem is that
if
gt; somebody needs to change information (in cells other than those labeled as
gt; quot;changing cellsquot; in the scenario) after the scenarios are run the quot;result
gt; cellsquot; do not change accordingly. Do they need to re-run the scenarios
every
gt; time if information changes, or is there a way to refresh the information
in
gt; the pivot table for each scenario? I am new to using pivot tables. The
gt; refresh button on my toolbar is grayed out for my pivot table. Hopefully
I
gt; am explaining this correctly. Any help would be greatly appreciated.
Thanks!
gt;
gt; Jaclyn
That's what I was afraid of. Glad somebody could verify that for me. Thanks
for your help!

Jaclyn

quot;Debra Dalgleishquot; wrote:

gt; You can't refresh the pivot table that's created by the Scenario Manager. If
gt; the information changes, you can create a new copy of the pivot table.
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt; quot;Fin Analystquot; gt; wrote in message
gt; ...
gt; gt; Good morning. I am hoping somebody knows the answer to this. I have
gt; three
gt; gt; scenarios that I need run for a complicated workbook I have set up. When
gt; I
gt; gt; run the scenarios I have them put into a pivot table. The problem is that
gt; if
gt; gt; somebody needs to change information (in cells other than those labeled as
gt; gt; quot;changing cellsquot; in the scenario) after the scenarios are run the quot;result
gt; gt; cellsquot; do not change accordingly. Do they need to re-run the scenarios
gt; every
gt; gt; time if information changes, or is there a way to refresh the information
gt; in
gt; gt; the pivot table for each scenario? I am new to using pivot tables. The
gt; gt; refresh button on my toolbar is grayed out for my pivot table. Hopefully
gt; I
gt; gt; am explaining this correctly. Any help would be greatly appreciated.
gt; Thanks!
gt; gt;
gt; gt; Jaclyn
gt;
gt;
gt;