Hi All,
Hoping to get some help, I'm using the distance and time calculator, that is supplied on the chandoo website, I have my API for bing and everything is working 100% when I save things locally, I have it integrated into a excel project calculator for projects. Which basically calculates the distance from installers location to site, it the determines if overnight stays are required and calculates fuel costs and so forth. It works great, does what we need it to do. However, we're all working from home now, so when we save this from local machine to the network drive. Value errors are experienced.
I have asked chandoo on twitter and posted it on their forums, we think it might be a limitation in the WEBSERVICE call but he hasn't got back to me and if it I can't resolve I'll need to consider a change. As it completely messes up the calculation requiring it all to be entered on a new calc book.
Any help appreciated. I have linked to the two sheets as upload mini sheet doesn't appear to be working (Chrome) and it one saved locally, one saved remotely. They are one in the same just different save locations. However, as I have uploaded both they are both likely have the value error which stems from the PC (postcode) sheet but both local works here, remote doesn't once downloaded
You can see from the snapshots, it is working.
Hoping to get some help, I'm using the distance and time calculator, that is supplied on the chandoo website, I have my API for bing and everything is working 100% when I save things locally, I have it integrated into a excel project calculator for projects. Which basically calculates the distance from installers location to site, it the determines if overnight stays are required and calculates fuel costs and so forth. It works great, does what we need it to do. However, we're all working from home now, so when we save this from local machine to the network drive. Value errors are experienced.
I have asked chandoo on twitter and posted it on their forums, we think it might be a limitation in the WEBSERVICE call but he hasn't got back to me and if it I can't resolve I'll need to consider a change. As it completely messes up the calculation requiring it all to be entered on a new calc book.
Any help appreciated. I have linked to the two sheets as upload mini sheet doesn't appear to be working (Chrome) and it one saved locally, one saved remotely. They are one in the same just different save locations. However, as I have uploaded both they are both likely have the value error which stems from the PC (postcode) sheet but both local works here, remote doesn't once downloaded
You can see from the snapshots, it is working.
