Microsoft's suggestion is that you do not have trusted locations on your community as destinations outside the house your computer are fewer Secure. The default placing reflects this. On top of that, Based on Microsoft, you need to stay away from introducing public folders on network shares as trustworthy locations. https://www.customguide.com/excel/pivot-table-excel