Refresh scenario information in a pivot table

F

Fin Analyst

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
 
D

Debra Dalgleish

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.
 
F

Fin Analyst

That's what I was afraid of. Glad somebody could verify that for me. Thanks
for your help!

Jaclyn
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top