A PivotTable on the range you are copying is connected to an embedded data source. Excel will copy the embedded data to |. ...