ExcelBanter - Refreshing privot table data in 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Refreshing privot table data in 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/205538-refreshing-privot-table-data-2007-a.html)

smartgal

Refreshing privot table data in 2007

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 . . . :-(

Roger Govier[_3_]

Refreshing privot table data in 2007

Hi

Click on any cell in the PTOptions tabData sectionChange Source data.

If you do want to invoke the Wizard, Alt+D+P

--
Regards
Roger Govier

"smartgal" wrote in message
...
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 . . . :-(

All times are GMT +1. The time now is 05:49 AM.