Home

Webservice exceeds 32676 limit

%3CLINGO-SUB%20id%3D%22lingo-sub-890464%22%20slang%3D%22en-US%22%3EWebservice%20exceeds%2032676%20limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-890464%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20getting%20a%20%23VALUE!%20error%20on%20a%20website%20that%20had%20previously%20worked.%26nbsp%3B%20If%20I%20manually%20insert%20the%20source%20into%20the%20spreadsheet%2C%20it%20accepts%20it%20even%20though%20the%20number%20of%20characters%20is%20over%2071%2C000.%26nbsp%3B%20Microsoft%20says%20that%20the%20%23VALUE!%20error%20is%20thrown%20for%20several%20reasons%20-%20unable%20to%20get%20to%20website%2C%20ftp%20or%20file%20protocols%2C%20url%20is%20too%20long%20(2048).%26nbsp%3B%20I%20have%20eliminated%20all%20the%20other%20reasons%2C%20so%20I%20am%20left%20with%20believing%20that%20it%20is%20the%2032%2C676%20bytes.%26nbsp%3B%20Does%20anyone%20know%20a%20way%20around%20this%20or%20another%20explanation%20for%20the%20%23VALUE!%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-890464%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
HnRShirley
Occasional Visitor

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!?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies