Excel WEBSERVICE with XML History #VALUE error

  • 3
  • Problem
  • Updated 8 months ago
Trying to use =WEBSERVICE() function in excel with =FILTERXML() to pull historical data. The functions work for today's date, but does not work with previous dates (So character limit is not the problem). The xml link opens when I click on it and has the data and it is counted in my usage stats, but excel returns #VALUE in the cell. Also, JSON works fine, but XML does not but because I need to use FILTERXML, I cannot use JSON format. Is there anyway to fix this?
Photo of Jordan Coe

Jordan Coe

  • 4 Posts
  • 0 Reply Likes
  • Frustrated

Posted 2 years ago

  • 3
Photo of John S

John S

  • 3 Posts
  • 0 Reply Likes
Same problem...no solution so far, have you had any luck finding a work around?
Photo of rollins_matt

rollins_matt

  • 1 Post
  • 0 Reply Likes
Is this ever going to get fixed?