Run-Time Error '1004' Cannot open PivotTable source file 'Consolidated Report'

Hi,

I am having the same problem with dynamic data filling in excel sheet.
Is your problem is solved? Then please reply me or send me on my email
[email protected].

Thanks
Amit Nain

Originally Posted by Aswathy

Hi All,

I have a macro that takes the date from different excel sheets, consolidates the data and renders the pivot table and chart accordingly. It was working fine when the date range defined for the pivot table was static. Now I have made it dynamic since the data range changes each month depending on the number of days it has got.

When I run the macro, it runs succesfully, generates the report and save & close the report, but after that I am getting this error.

Errorneous code:

Please Login or Register  to view this content.

I have attached theexcel file as well. Please check the code in Module1.

Can anyone help me on why this error is happening.