Every time i try to refresh data in a worksheet using the pivot table, i
get a popup saying
"Performing this operation requires using a query to refresh external
data. a malicious user can design a query to access confidential
information and distribute it to other users can perform harmful
actions. do you want to query and refresh the data in this workbook"

Is there any way i can disable this popup?

Any pointer in this regard would be most helpul.