[Err1004] Copy error due to PivotTable or Table

[immigrated4urjob]

I get the error stating that I can't make this change (or copy a range to a destination) because it will affect Pivot Table.

Now there are two solutions I thought of:

• Deleting Pivot Tables entirely. But this is pointless as my report requires it.
• Referencing table in targetWb.Sheets(n).Range("A2"). How would you copy a range to a destination that is a listobject in position cell A2?

Essentially, I am trying to import workbook from range to a table that is connected to a PivotTable.

Please Login or Register  to view this content.

[6StringJazzer]

Please attach the actual file so we can see where everything is. (See yellow banner at the top of the page.)