Run-time error '1004': Copy method of Range class failed Excel 2013 when adding a new pivot table
<p>I am getting the error specified in the title of this issue when trying to copy and paste some columns (and it's data) to a new workbook.
The code below used to work till the moment when I add a new sheet with a new pivot table in my workbook, and I don't know the reason:</p>

<pre><code>Sub ExtractData_2()

  Workbooks.Add
  ActiveWorkbook.SaveAs ThisWorkbook.Path &amp; "\extract_Fcst" &amp; ".csv", 6
  ThisWorkbook.Worksheets("Forecast Enrichment").Activate

  ThisWorkbook.Sheets("Forecast Enrichment").Range("E:S").Copy Destination:=Workbooks("extract_Fcst.csv").Sheets(1).Range("A:O")

  Workbooks("extract_Fcst.csv").Sheets(1).Range("A:O").EntireColumn.AutoFit

End Sub
</code></pre>

<p>Does anybody have any idea to how to solve that problem? I have tried a lot of different solutions found in google but any of it works!</p>