[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • 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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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