Pivot Table Refresh

[Hal Kipling]

Excel 2003, Sp3. After I add data to the Source sheet and click the Refresh icon or a Refresh menu itrem nothing changes. I don't have any blank rows, column or cells. No grouping. What am I not doing right?

[MarvinP]

Hi Hal,
You may have to reset the range of data for your pivot table. If you add data to the bottom of the range and don't include it, no changes to the pivot will appear.

[Hal Kipling]

Hello MarvinP,

Thank you for the reply. How does one reset the data range without starting the Wizard and going through the table setup again?

[DonkeyOte]

use a Dynamic Range as source, see: http://www.contextures.com/xlPivot01.html

[Hal Kipling]

DonkeyOte,

I've got it now! Thank you. You can mark this one SOLVED. I would do it, but I don't know how.

Hal