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.
- =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.
In a March 2025 update to the Spreadsheets application, those two functions were deprecated. You can now set the country and region within each function to help prevent erroneous location matches in other countries or regions. These setting 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. |