Excel Webservice

[Swi]

Hi,

I am using the following code to return a web service API call from the USPS.

=FILTERXML(WEBSERVICE("http://production.shippingapis.com/ShippingAPI.dll?API=TrackV2&XML=%3CTrackRequest%20USERID=%22"&$E$1&"%22%3E%3CTrackID%20ID=%22"&D3& "%22%3E%3C/TrackID%3E%3C/TrackRequest%3E"),"/TrackResponse/TrackInfo/TrackSummary[1]")

However, when I publish/save to OneDrive as a shared document if you edit the cell and hit enter to update it for any reason you get a #VALUE! in the cell.

Any ideas or is this a limitation of a shared Excel document online.

 

[dhookom]

Do you get the same result when using locally? Does other functionality work when using OneDrive?