Microsoft's suggestion is you don't have dependable areas on your community as areas outside the house your computer are fewer Protected. The default location demonstrates this. On top of that, In keeping with Microsoft, you need to steer clear of including general public folders on network shares as trusted locations. https://www.customguide.com/excel/data-validation-excel