If you just want to change the source data range of your pivot table to a
name that you created....... Pull up the pivot table wizard. Click the back
button. You should now be at the part where you select the range. Delete
what is in the dialogue box currently. Then place your cursor in the field
and follow the Excel menu path Insert / Name / Paste. Choose the proper name
and click Ok.

Hope this helps.

Bill Horton

"thunderbirds" wrote:

The data for my pivot table is an ever increasing list of rows with 20 fixed
columns. Rather than constantly extending the source data range, I have used
'Define Name' and created an OFFSET formula. However how do I now get the
pivot table to use this instaed of the original data range.