Fix Runtime error 1004:A table cannot overlap a range that contains a PivotTableReport...

Hi,

I m using Excel 2010.
I used a macro recording to record the activity i.e., pull the data from a iqy file(web query file generated when you do Export to Excel in a SharePoint site to export SharePoint list data to Excel.). I want to run this macro on daily basis. However the problem is when you try to re- run the same macro I get error Run-time error '1004'
A table cannot overlap a range that contains a PivotTable Report, query results, protected cells or another table.

Any reasons why?

What would be the solution to my problem? Thanks.



RunTimeErr.JPG

Please Login or Register  to view this content.