Excel 2013 has given a function to fetch data from web (internet or intranet), which is know as WEBSERVICE

As name suggests, this function can be used to get data from a webservice.





where url is the link surrounded by quotes or a reference to a cell containing link


Below are some possible errors and their description:-

  • #N/A! error may come if the web service is not available or if it does not respond before the timeout (3 seconds)
  • #VALUE! error may come if arguments are unable to return the data OR argument returns more than allowable cell limit of 32767 characters OR URL string contains more that 2048 characters

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.