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.