Refreshing privot table data in 2007

  • Thread starter Thread starter smartgal
  • Start date Start date
S

smartgal

What happened to the wizard?? I want to update my pivot table with new data
and can't find the option to update the data ranges. Help!! Bring back
classic menus . . . :-(
 
Hi

Click on any cell in the PT>Options tab>Data section>Change Source data.

If you do want to invoke the Wizard, Alt+D+P
 
You must log in or register to reply here.

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

Possible to create a customize Pivot Table Template? 2
pivot table source data expand to new entries when refresh? 4
How do I save Pivot Table Data 4
Pivot Table Refresh not working properly 1
Pivot Table - Just show Value in Summery no Calculation 2
Pivot Table Wizard in 2007 1
Dynamic data ranges in pivot tables 3
Change pivot table source data in Excel 2007 1

Back
Top