• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • Last Modified:

Adjust Page Breaks Automatically With a Pivot Refresh

In Excel 2007, I have a pivot and a chart a few rows underneath it.  Whenever the pivot refreshes, and new rows are added, the pivot overlaps the chart.  How do I get it to just insert rows and move the chart down when the pivot adds new rows?  I don't want to keep having to update the page breaks.  I'm having the same problem when a new column is added to the pivot.  In the file, the cell A1 is merged across to the end of the pivot going across. When a new column is added to the pivot, the merged cells do not extend all the way to the new column. Can this be done automatically?
0
error_prone
Asked:
error_prone
  • 3
1 Solution
 
Eric ZwiekhorstSAP Business ConsultantCommented:
can you give us a exaple file to work with..

Kind regards

Eric
0
 
Eric ZwiekhorstSAP Business ConsultantCommented:
You could use the
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
this is triggered everytime a pivot table is updated.

Now you can detect just how many row are filled by the pivot and move the chart accordingly...


Kind regards


Eric
0
 
puppydogbuddyCommented:
You can set page breaks that adjust automatically.  See this link:
            http://office.microsoft.com/en-us/excel-help/pivottable-reports-101-HA001034632.aspx
                        (Go to step 4 and expand the link)
0
 
error_proneAuthor Commented:
Thanks
0
 
Eric ZwiekhorstSAP Business ConsultantCommented:
Dear Error prone,

I am glad I could help.
I like to point to a solution rather than give the entire code.
For me it was always better to make something myself with a little help then just copy paste the entire solution...

So thanks for the points and the grade

Kind regards


Eric
0
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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