FindRouteByAddress showing #VALUE!

[DanielEtelman]

I've been using the FINDROUTEBYADDRESS function for several weeks now and it has worked great.  I have a spreadsheet with customer data linked to Access which updates whenever I open the spreadsheet.  The address data is referenced in a cell which concatenates 3 different fields: Street, City, and Zip. As of yesterday, 7/22/25, the function is no longer working and it just shows the #VALUE! error.

I've tried changing the reference, the address format (with and without commas), the address fields (street only; street, city, zip, and state) and nothing is working.  I haven't changed anything with my address fields before this problem occurred.

Daniel

[CodyPatterson]

Hey @DanielEtelman 

Would it be possible to check if you're logged into the Excel sheet? Along those lines, would restarting the computer or refreshing the add-on be possible? There may be an issue during the loading of the Excel sheet that may have cached in.

Cody

[DanielEtelman]

Hey Cody,

I'm logged into Excel and logged into ArcGIS. My computer has been restarted but I'm not sure how to refresh the add in. Everything else i use in the add in works. The map updates as I update the connected table and I can add new layers.

[CodyPatterson]

Hey @DanielEtelman 

Definitely very strange, would it be possible to rebuild the function from one input at a time? Maybe start with example data and then work back into a more complex function? It could be the chance that the data being entered may have encountered something wrong or invalid, and it attempting a calculation on the bad data.

Cody

[DanielEtelman]

Cody,

I've tried that, as well. The minimum inputs required are the "from address" and "to address".  I've entered those directly into the formula using several formats (Street only, street + ZIP, street + city, street + city + ZIP), i've referenced cells with the address either as a single address component or concatenated from multiple cells.

It's annoying because it had been working for weeks with no issue.  I'm signed into excel and signed into ESRI. I'm using the ESRI map which contains layers that are drawn from my customer address table as well as a polygon feature from my ArcGIS "My content" folder. I use ArcMap almost everyday and that subscription is working fine.  I didn't change anything about my data or my user licenses before this happened.

[DanielEtelman]

I created a new workbook and tested the function, and it works there.  So I copied the workbook I have been using and tried 1-by-1 deleting data connections, pivot tables, and spreadsheets to see if I would eventually eliminate the problem that way, but that did not work.  I guess it's a setting or something in the workbook itself that has broken the function.  I'll post if I can figure it out in the future.  I'm going to try adding all my tabs from the broken workbook into the one that now works and see if/when it breaks.

[ShannonCardoza]

Good afternoon @DanielEtelman, nicely done on troubleshooting and posting your questions here! Thank you for that.

Unfortunatly, the error you are receiving is a bit generic, right? I have an old post, here, that briefly describes the solution as > A value used in the formula is of the wrong data type. My guess is the value was changed somewhere, which is tied to the formula. Seems as if you are currently working through troubleshooting steps so please keep me posted if you find the solution or if you need additional help!

All the best, 

SC