CODEWITHSUNDEEP
excel
user1592380
user1592380

Reputation: 36205

Excel add in not activated

enter image description here

I'm working with a list of addresses in excel 16. I want to perform a reverse geocode function to produce addresses from the available longitude and latitude info. to do this I have found an excel addin https://github.com/gramener/geocode-excel , which I downloaded. you can see an example in the screenshot above. the formula which it introduces is:

=@NominatimReverseGeocode(B32,C32)

Now what I want to do is make this available in my main sheet so that I can use the NominatimReverseGeocode.

I followed Adding macro from one excel sheet to another and got it working on my home computer. I'm now trying it on a work computer.

I emailed myself the geocode.xlam and added it via the developer ribbon:

enter image description here

However the functions do not show up in my sheet after closing and reopening. What am I doing wrong?

edit

enter image description here

edit2:

enter image description here

Upvotes: 0

Views: 103

Answers (1)

BigBen
BigBen

Reputation: 49998

I'm not sure exactly why, despite the add-in showing as active under File > Options > Add-ins, it hasn't actually been opened.

Try toggling the checkmark in the Excel Add-ins window off and on, which should (re)load the add-in.

As a check, you can open the VB Editor (Alt+F11). You should see the add-in in the Project Explorer (Ctrl+R).

Upvotes: 1

Related Questions