Pivot table question

I have a workbook that has two worksheets.  One is labeled 'Pivot' and the other is labeled 'raw data'.  Pretty basic, the pivot table pulls the raw data.

What I would like to know if there is a way for me to use this over and over again (and have others use it as well) WITHOUT having to modify the range of the data each and every time the raw data is updated.

In other words, we use this every couple of weeks, or maybe once a month.  Basically we blow the data out that is on the raw data tab and paste new data, which is formatted exactly the same, into it's place.  However, the row count may vary. thus we have to adjust the range every time.

Is there not a way that we can paste new data and refresh the pivot table without having to adjust the range each tiime?   Thanks.
Who is Participating?
Patrick MatthewsConnect With a Mentor Commented:

My article http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_3172-How-to-Automatically-Update-Your-PivotTables-and-PivotCharts.html discusses a few options for doing this.

In Excel 2007 or later, using a Table as the data source makes the most sense.

In Excel 2003 or earlier, a dynamic named range is best.

Let me know if you need any help implementing these strategies.

I may suggest to specify the maximum rows that you may have in your range. In such a way, when the count of rows increased the range is not affected.

snyperjAuthor Commented:
Your article appears to address all of the issues.  Well done.
Patrick MatthewsCommented:

Glad to help!  If you have not already done so, I would really appreciate it if you could please return to my article
and click 'Yes' for the 'Was this helpful?' voting.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.