I am getting a #VALUE! error on a website that had previously worked. If I manually insert the source into the spreadsheet, it accepts it even though the number of characters is over 71,000. Microsoft says that the #VALUE! error is thrown for several reasons - unable to get to website, ftp or file protocols, url is too long (2048). I have eliminated all the other reasons, so I am left with believing that it is the 32,676 bytes. Does anyone know a way around this or another explanation for the #VALUE!?
