Hi, prabhuduraraj09,

if you open a woirkbookand want to refresh pivots in that workbook it´s not ThisWorkbook (which is the workbook with the code) but ActiveWorkbook (as that workbook would be the last one being opened). Waiting for the full code to have a look at.

Ciao,
Holger