Can't open PivotTable source file

Hi All,

I'm facing an issue on excel pivot table. Please help me on the below issue.

I have copied data from one excel file data to destination file and did a lookup activity in one field on destination file from another external file. up to this no issue.but if I try to refresh all sheets getting an error.

Error : can't open Pivot Table source file 'C:\Path\[destinationfile.xlsx]sheetname.

But the sheet is not presented in my destination file. for example the original sheet name is 'ABC', but in the error it is showing as ABC1. (I'm not using ABC1 sheet any where in destination file).

Please help me on this issue. Thanks in advance.

Thanks,

Krishna.