PC*Miler Web Services Spreadsheets includes two functions that allow you to set a worldwide region and a country to narrow and improve location search results. In a March 2025 update to the Spreadsheets application, these two functions were deprecated

  • =SetDefaultRegionWS( ): Sets the worldwide region (NA, EU, WW, SA, AS, OC, AF, ME) used for location searches. 
  • =SetDefaultCountryWS( ): Sets the country (e.g. US, CA, UK, MX) used for location searches. 


You can now set the country and region within each function to help prevent erroneous location matches in other countries or regions. These settings also may improve performance by reducing the search's scope.



Contact us to download the latest version.


Region

ArgumentDescriptionValues
RegionThe default worldwide region you want to use for location searches.NA - North America
EU - Europe
WW - Worldwide data
SA - South America
AS - Asia
OC - Oceania
AF - Africa
ME - Middle East


Country

ArgumentDescriptionValues
CountryThe default country you want to use for location searches.A two-letter country code.