I have a web query set up (ie Data>>From Web) where the source is connected via an API.
Everything is working great as long as the data set is relatively small - I can manipulate the parameters by date and it is working for 2 months (~13K rows) but if I change it to 6 months then I get this error:
"TheWeb.Page function requires Active Scripting to be enabled in Internet Exploreroptions"
I know that it is not a problem with the data source because if I change the format to be CSV then the data does all come through, but all in one column in html code. If I could delimit it neatly then that would also do the trick but it also ends up with every second row being blank.
Please note that I have found instructions to change this setting in Internet Explorer, but I don't have Internet Explorer on this computer, only Edge which doesn't seem to have the same options.
Also, I have tried running on an older computer that does have Internet Explorer and got the same error. But when I followed the directions to change the settings I found that Active Scripting was already enabled.
Hoping someone can help!
Everything is working great as long as the data set is relatively small - I can manipulate the parameters by date and it is working for 2 months (~13K rows) but if I change it to 6 months then I get this error:
"TheWeb.Page function requires Active Scripting to be enabled in Internet Exploreroptions"
I know that it is not a problem with the data source because if I change the format to be CSV then the data does all come through, but all in one column in html code. If I could delimit it neatly then that would also do the trick but it also ends up with every second row being blank.
Please note that I have found instructions to change this setting in Internet Explorer, but I don't have Internet Explorer on this computer, only Edge which doesn't seem to have the same options.
Also, I have tried running on an older computer that does have Internet Explorer and got the same error. But when I followed the directions to change the settings I found that Active Scripting was already enabled.
Hoping someone can help!