Excel 2010 Pivot Tables

I Have just switched to using Excel 2010 (from 2003) and I am having difficulty in changing the data range for a pivot table when I have added further data at the bottom. In 2003, you could right click within the pivot table and use the 'Pivot Table Wizard' to do this but I cannot see anytning similar in 2010.

I am getting around this by inserting additional rows in the middle of the data and then pasting the new data in these cells, but this seems a really long winded way of doing it.

I am missing something here?

Hi

Pivot table tools tab, Options tab, Change data source button. That should do it for you.

Chris

Thanks Chris, had not noticed that tab so I clearly was missing something .

No worries its a real pain transferring from 2003 to later versions and it dont help when tabs like pivot table are not on display all the time.

Chris

Please help me anybody by solving this questions...

1. You are creating a new formatting rule which will be used to format a PivotTable report. Which of the following formatting styles is NOT available while formatting all cells of PivotTable report based on their values in an MS Excel 2010 worksheet?
a. 2-Color Scale
b. 3-Color Scale
c. 4-Color Scale
d. Data Bar

2. Which of the following statements is true regarding PowerPivot in Microsoft Excel 2010?
a. One limitation of PowerPivot is that it does not allow access to Slicers when working on data in PowerPivot.
b. A connection to a server running SQL Server Analysis Services is required to answer PivotTable queries by the PowerPivot engine.
c. Version control and tracking is supported by PowerPivot.

3. Which of the following statements is NOT true regarding import of data into PowerPivot?
a. Data can be imported into PowerPivot by either selecting list of tables or by writing SQL query.
b. The data being imported into PowerPivot can be filtered before the import.
c. The PowerPivot Import Wizard provides you with an SQL Query builder.

4. Which of the following statements are true regarding PowerPivot in Microsoft Excel 2010?
a. PowerPivot streamlines the process of integrating data from multiple sources like databases, spreadsheets, reports and text files.
b. PowerPivot does not allow access to slicers when working on data in PowerPivot.
c. Version control and tracking are NOT supported by PowerPivot.

5. Deleting a PivotChart report automatically deletes the associated PivotTable report.
a. True
b. False