PivotTable update

%3CLINGO-SUB%20id%3D%22lingo-sub-2375678%22%20slang%3D%22en-US%22%3EPivotTable%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2375678%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%20I%20can't%20seem%20to%20be%20able%20to%20update%20a%20pivot%20Table%20in%20a%20.xlsb%20from%20a%20shared%20drive.%20Is%20there%20a%20limit%20of%20content%20for%20refreshing%20a%20pivot%20Table%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2375678%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2375708%22%20slang%3D%22en-US%22%3ERE%3A%20PivotTable%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2375708%22%20slang%3D%22en-US%22%3EI%20also%20tried%20to%20save%20it%20local%20and%20refresh%20the%20Pivot%20Table%20in%20a%20specific%20sheet%20and%20it%20freezes.%3C%2FLINGO-BODY%3E
New Contributor

Hi. I can't seem to be able to update a pivot Table in a .xlsb from a shared drive. Is there a limit of content for refreshing a pivot Table? 

1 Reply
I also tried to save it local and refresh the Pivot Table in a specific sheet and it freezes.