• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Moving already existing data to right or below a Pivot Table on refresh

B

balak2205

New Member
Hello all !


Is there a way to Dynamically Move data/formulae to the right or below a Pivot Table, if pivot data increases on refresh.

OR

Is there any other alternative, if i want to keep my data on a pivot sheet?


Thanks in advance for your advise and help.
 
Balak2205


Firstly welcome to the Chandoo.org Forums


Generally I recommend that people keep Pivot Tables away from data so that this is not an issue


Generally you just need to keep your data well to the right or below the pivot table so that you allow for the worst case expansion of the pivot table. You can make the worksheet more manageable by using the Outline Group tools (Select Rows/Columns and Alt Shift Right Arrow) to hide the rows/columns between the edge of the Pivot and your data area


You could possibly use some VBA to insert rows/columns every time the pivot changes, but I've never done that.
 
You must log in or register to reply here.
Back
Top