Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

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.
0
snyperj
Asked:
snyperj
  • 2
1 Solution
 
MINDSUPERBCommented:
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.

Sincerely,
Ed
0
 
Patrick MatthewsCommented:
snyperj,

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.

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

Glad to help!  If you have not already done so, I would really appreciate it if you could please return to 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
and click 'Yes' for the 'Was this helpful?' voting.

Patrick
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now