i'm using excel with VBA and the google API distance matrix to calculate distances between two locations each time for a long list of locations. I use a google API with activated billing account associated to the API. I use serviceweb in excel to retrieve the distance from google. The formula in excel works fine but only for three queries, after I need to wait for a minute to resend three more. In the quota page of google I see this: enter image description here But it's not possible to extend the quota even though I have billing account associated. is there something I'm doing wrong ? I would like to use the formula on several hundreds of lines containing the locations (each time to get distance between two different locations).
Thanks a lot for your help !!
I cannot change the quotas in google. I looked at the quotas under the section "Premium plan Javascript API elements" and "Premium plan web service elements" and they would be perfect as the limit is super high but I can't get those to work..