Overlapping Pivot Table - that I can't fix

[Domroy]

I have a massive workbook, that has macros, and pulls data and places it in another file.

When I place it manually, and then update the pivot tables, it has no problem.

When I allow the macro to place the data, (it places it in exactly the same place), then I refresh the pivots, it tells me that I can't overlap. I didn't build the initial file, so I ran this macro:

<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">Sub ref()

Dim Sheet As Worksheet, Pivot As PivotTable, result As Boolean
For Each Sheet In ThisWorkbook.Worksheets
    For Each Pivot In Sheet.PivotTables
        Debug.Print Sheet.name & "-->" & Pivot.name
        Pivot.RefreshTable
    Next
Next

End Sub

In the Immediate Window, it told me which Pivot table is the problem, but I can't seem to fix it, and it ISN'T overlapping. Thoughts?</code>

 

[mole999]

you need more coloumns than you think between pivots, they have to be able to expand, even if they don't

 

[Domroy]

I'll try that. But do I need to worry about pivot charts? They don't need to expand, they just change their information...but keep the same footprint...right?

 

[mole999]

i'm not sure of any rules just have struggled with errors until i made the space. i tend to add ten columns and hide them to avoid the issue