Vba to Fix Pivot overlapping
Posted on 2013-05-15
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.