PinPop looks up each address once and keeps the result in your table. That keeps Google costs low, but sometimes you want fresh answers: after cleaning up many addresses, when Google has improved its data for your area, or to keep cached results current. Look up all addresses again looks up again every row PinPop looked up before, and the rows that still have no coordinates.
Steps #
- Open More options in the toolbar.
- Click Look up all addresses again.
PinPop looks up the rows again with your Google key and overwrites their Latitude, Longitude and Match values. Above 500 lookups it asks first, as on the first run. The progress shows in the frame with Cancel, and every row done so far is kept. The other rows keep the coordinates they had.
If no row has an address to look up, it says No rows have an address to look up.
To look up only the rows that have no coordinates yet, use More options > Look up N addresses, for example Look up 12 addresses. The item shows only while such rows exist. After you stop a first run with Cancel, the line under the map also offers Look up the rest.
Which rows are looked up again #
- Looked up again: rows with a Match value from PinPop, such as Exact, Street, Area, Approximate or Check, and rows with an address but no coordinates yet.
- Never touched: coordinates you typed yourself, or that came with the table. PinPop treats coordinates without a Match value, or next to Not found, as yours.
The free version looks up the rows inside its 50-pin limit.
Look up one row again #
You rarely need the whole run for one row:
- The address changed: edit the address cell while the map is open, and PinPop looks that row up again by itself.
- Same address, new answer wanted: clear the row’s Latitude, Longitude and Match cells. PinPop looks it up from its address.
- You know the right place: type the coordinates over PinPop’s. They are yours from then on and never overwritten.
What it costs #
Each row looked up again is one lookup on your Google key, billed like the first one. A table of 2,000 looked-up rows means 2,000 lookups. See Is the Google Maps key free?
Edited addresses that were changed while no map was open, for example in a copy of the workbook, are found by Look up all addresses again too.
