Scenario Pivot Table

B

blueberry80

Hi ,
will like to ask for help on excel scenario pivot table. I try to use
the data from another spreadsheet and using the tools->scenario to
create the scenario pivot table. But when i tried to refresh the data ,
the 'refresh data' is disabled and i'm not too sure why. Any idea??
Does scenario pivot table allows us to refresh data ??


Thanks
 
D

Debra Dalgleish

You can't refresh the Scenario Summary pivot table. You could run the
summary again, to recreate the pivot table, if the scenarios change.
 

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

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Pivot Table cell values 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot table report invalid 0
Pivot Table Data Aggregation 0
Pivot table column help 2
Returning 1 of 4 values if conditions are met 4
Retain pivot table formatting after refreshing data 0

Top