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?