Q&A

Q1:The cell references in the Range box in the first PivotTable and PivotChart Wizard dialog box are wrong. What next?
A1: If the range is incorrect, click in the Range box and type the correct cell references. A quick way to specify the range in the Range box is to highlight the range in the worksheet.
Q2:I want to change the data in the pivot table, but Excel won't let me. What can I do?
A2: Excel doesn't allow you to change the data directly in the pivot table, but you can change the data in the source, such as the Excel list. After you make the changes, click the Refresh External Data button on the PivotTable toolbar to update the data in the pivot table, reflecting the changes you made in the source list.
Q3:After I create a pivot table, ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.