block user from refreshing pivit tabel

[BORUCH]

hi

is there a way through an excel vba to disable the refresh button in excel for a power pivot table or any type of refresh ?

i don't want to protect the sheet i just want to disable refreshing it (with a password)

 

[James006]

Hello,

See if this thread can help you out ...

https://www.mrexcel.com/forum/excel-questions/810096-prevent-using-pivot-table-refreshall.html