eyelenchukgmailcom The script error typically pops up when using the 'legacy' method. Have you tried using Data | From Web?

yes ,that what exactly i was trying to doPatrick2788

eyelenchukgmailcom It may help if you list the version of Excel you're running. This is the menu that opens for me:

it is opened for me like this when I do the following steps -New query-other sources-from WEB

Forum Discussion

Copper Contributor

Feb 16, 2024

I am trying to get data from WEB in Excel but repetedly get an error