Receiving a ‘REQUEST_DENIED’ error in Excel when attempting to use the add-in? First make sure you’re using a version of Excel 2013 or newer.
If you’re using a compatible version of Excel, then the issue is due to your Google API key. The ‘Server Denied’ or ‘Request Denied’ error is similar to an ‘incorrect password’ error when attempting to login to a website.
Effectively, Google doesn’t recognize the API key you’ve added to the Add-in or the Google API key was not setup correctly.
Return to the ‘Using the A.CRE Geocoding Add-in’ section, paying special attention to the Google instructional videos in items 1 through 5.
Also make sure you’ve properly added the API key to the A.CRE Geocoding Add-in by reviewing the instructions in the ‘Adding the API Key to the A.CRE Geocoding Add-in in Excel’ section at the link above.