Excel WEBSERVICE with XML History #VALUE error
Trying to use =WEBSERVICE() function in excel with =FILTERXML() to pull historical data. The functions work for today's date, but does no...
John S
Joined on April 24, 2017
0
Likes received
0
Conversations posted
3
Replies posted
0
Conversations followed
Conversations
Update Weather History in MS Excel using Webservice Function
I recently set up an excel spreadsheet to bring in past weather averages for each day since the beginning of the year.
I am doing this...
Excel 2013 "history" API formula not returning values other than for today's date.
This is my API Webservice formula, which is returning #VALUE! error when I use a plug date other than today. It works perfectly for toda...