Changing a pivot table's data range in Excel 2007

G

Guest

In Excel 2007, I want to modify the data range for an existing pivot table.
I don't know how to do that. When I click inside the existing pivot table to
make it active, the pivot table icon in the ribbon is grayed out and I can't
select it. I can't find the appropriate menu item when I right-click.
 
N

Nick Hodge

Ken

Click in the pivot table and you will get two extra tabs on the ribbon under
'PivotTable Tools' (Options and Design). Click on options and in the Data
group you will find a 'change data source button', one of the options here
will help you depending on whether it's data from Excel or an external
source

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk
 

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

Adding data to a 2007 pivot table 2
Pivot table field list missing 5
Pivot table data source 1
Excel 2007 Pivot Tables compatible with 2003 3
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Wizard causes crash 1
Pivot using 250,000 rows of data in Excel? 1
Pivot Tables: Excel 2003 vs Excel 2007 2

Top