Distance Matrix VBA Error

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

I’ve been using the distance matrix API and it’s been working perfectly, but when I save the excel file all the values turn to the error (-1). Any idea why? I’m using the formula on a direct connection, and only until the 2,500 requirement.

deleted comment

Best option is to use the Distance Matrix API only in a manually executed Macro. In case you use it in a UDF then during recalculation if the network connection does not respond you will get -1 due to the error messages.

Simply the best place to learn Excel VBA