Good day, somebody knows if it's possible to be able to refresh pivot tables on a shared workbook without having to remove the shared functionality.

Thanks in advance.