I have a spreadsheet that has short (50-80) rows with 7 columns. 2 columns are used to calculate data. Calculations use Google Maps to get mileage from one point to another point. The calculations either work or don't work. That is, the calculated cells either have the correct mileage or have a 0. I have tried "refresh all" and "recalculate". Neither of these causes a change.
However, when I copy/paste from another cell that shows the correct mileage OR a cell that has a zero, the calculation immediately works and is correct. This works every time.
The process is to use a listbox to select an employee. This employee has a work zip code used in the calculation. Other employees are added to the list (programmatically) where a column is used to calculate their personal zip codes and determine mileage using the work zip code. If I add other employees one at a time, there is no problem. It is only when employees are added fast does this fail.
Is there a way to correct this, or a workaround?
However, when I copy/paste from another cell that shows the correct mileage OR a cell that has a zero, the calculation immediately works and is correct. This works every time.
The process is to use a listbox to select an employee. This employee has a work zip code used in the calculation. Other employees are added to the list (programmatically) where a column is used to calculate their personal zip codes and determine mileage using the work zip code. If I add other employees one at a time, there is no problem. It is only when employees are added fast does this fail.
Is there a way to correct this, or a workaround?
Last edited:
