Jim,
I'm having the same problem with updating my pivot table's source range. I'm
using Excel 2007. However, when I right click on my pivot table, the wizard
doesn't display in the contextual menu. Any thoughts on this?
Thanks,
Patti

"Jim Thomlinson" wrote:

Pivot tables have a source range. If you added or removed rows you will need
to reset the source range. Right click on the pivot table and select the
wizard. When the dialog comes up select the back button to get back to where
you set your source range... Modify as necessary. This is an ideal spot for a
dynamic named range. Check out this link...

http://www.cpearson.com/excel/named.htm
--
HTH...

Jim Thomlinson


"KateW" wrote:

I've been trying to add data (new rows) and then refresh my pivot to show the
changes but it isn't working and I suspect there's something basic here I'm
missing. I've looked at my Excel Step by Step book and all it says is add
the data and refresh which I've done. I created the pivot by clicking in the
data and then setting it up - do I need to link to the data in a different
way to get added rows? Office Online and Help don't seem to address this
basic issue.