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?
 
P

paulgu

Joined
Apr 29, 2008
Messages
66
Reaction score
0
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?
 

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

Excel 2007 pivot table source table 1
Pivot Table Data Source 1
Pivot table change data source 1
Column limit for Pivot Table data source 1
Move and Copy Pivot Table and Source Data 4
pivot table source data expand to new entries when refresh? 4
How can I change the source data reference to another pivot table? 2
pivot table data 2

Top