Sharing a workbook disables lots of features. If you look in Excel's help for:
Features that are unavailable in shared workbooks

You'll see refreshing a pivottable is one of those features.

EED wrote:

I have a few pivot tables on a shared workbook. I have it set to refresh
when the workbook is open, which that works until I Share the workbook.
After its shared, it will no longer update/refresh. Is there a way to do
this or possible? Thanks!

--

Dave Peterson