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
Argument | Description | Values |
Region | The 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
Argument | Description | Values |
Country | The default country you want to use for location searches. | A two-letter country code. |