O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required