How to refreshing the pivot table while the excel sheet in shared?

Because, I am working in beloved in BPO so my office pc entirely connected
on network drives. so I face this problem. Kindly do the needful things.

Thanks in advance.

regards,
Nagarajan.K