Scenario Pivot Table

  • Thread starter Thread starter blueberry80
  • Start date Start date
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
 
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

Pivot table column help 2
Apply Filter to source of Pivot Table 2
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh 1
Adding data to a 2007 pivot table 2
PivotTable auto-refresh with external data 4
Pivot Table with Data Model Connection - getpivotdata reference issue 0
How to clear data in pivot table? 4
Pivot table to calculate variance showing budget and actual. 2

Back
Top