Pivot Table Refresh

[ctrapper]

I will use a short example, I am not in a place I can upload the doc, but maybe this will be easy to answer. I have a bunch of data in Sheet 1, down through Row 100. In Sheet 2, I have created a pivot table for that data by highlighting all the columns I need for my table. I am continue to add data to first sheet, I am now down to row 130, but when I refresh the Pivot Table, it give me an error, PivotTableField name not valid? Any thoughts? Does it have something to do with data being entered in cells that did not have data the first time the PivotTable was created?

[krjoshi]

Hi ctrapper,

May be you have selected row source without comlun header name (Title). Dont keep any column without header name between your data range. Please check once again. See the below picture for better understanding
PivotTable.GIF

[ctrapper]

That's it.. totally forgot I inserted 2 additional columns in Sheet 1 w/o naming them after I created the Pivot table! I missed it when I was checking things.. thanks!

[krjoshi]

No problem. If you are satisfied with the solution(s) provided, please mark your thread as Solved.
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.