Microsoft's recommendation is the fact that you don't have reliable locations on your network as destinations outside your computer are a lot less Risk-free. The default placing reflects this. In addition, In keeping with Microsoft, you need to avoid including general public folders on community shares as reliable destinations. WordCounter.Web https://www.customguide.com/excel/data-validation-excel