Perhaps you included a blank column when you created the database range.

Eleanor M wrote:
I have a similar problem with my pivot table.

Whenever I click on refresh data an error message displays that PivotTable
field name is not valid. I followed your website contexture on defining the
database word for word and it worked but now I try to refresh the data I get
the error message.

Please advise.

Best Regards,
EMoorhead


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html