Change pivot table source data in Excel 2007

P

paulgu

Joined
Apr 29, 2008
Messages
66
Reaction score
0
I've recently upgraded to Office 2007 after using 2003 for some time. I used to be able to change the source data for a pivot table by opening the pivot table wizard, stepping back to the first stage of the wizard and selecting a new range. However this seems to be impossible in 2007, so I have to delete the original pivot table and create a new one to change its source data, which is tedious.
Have I missed something? Can anyone tell me how to do this without creating a new table?
 
I've just found the answer to this myself. Click on the pivot table and and an additional menu item called Options appears cunningly hidden in the menu bar. This contains an option called Change Data Source.
Does this make any sense? Not to me. Why can't it be in the right click menu for a pivot table?
 
Back
Top