When every row fails, it is practically never the addresses. It is the Google key. Three causes cover almost all cases:
- Billing is not enabled on the Google Cloud project. Google requires it even inside the free tier.
- A required API is not enabled. The key needs the Maps JavaScript API and the Geocoding API enabled on its project.
- The key has a website restriction that blocks Excel. Either remove the HTTP referrer restriction or allow
https://addins.pythonandvba.com/*.
The status bar in the pane names the exact cause in plain language. After fixing, test the key again under Settings > Keys > Save and test.
