Link to home
Create AccountLog in
Avatar of montrof
montrofFlag for United States of America

asked on

Vba to Fix Pivot overlapping

Morning everyone,

I have a macro that loops through a directory and pulls back data from sql to update all the data tabs.  Then I refresh all the pivots in the workbook.  The issue I am having is sometimes the pivots will overlap and I will get an error message of "Do you want to replace the contents of the destination cells".   Since I am looping through 50 workbooks and at different time this can occur I was hoping that there was some way to programatically deal with the issue.  

Thanks,
Montrof
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of montrof

ASKER

Well it was not my design I am just automating the loading of the data to the spreadsheets.