Web Query limiting to 100 rows, nothing financial

[Evan99]

Hi! I just joined this forum out of desperation haha. I'm trying to link my Google Sheet to Excel Mac (latest version) and it limits the import to 100 rows, plus a message about "Finance Data Listing and Disclaimers." The Sheet I am trying to query has no formula related to anything financial. It is a simple list of Urls, about 700 rows in total. Can anyone help explain?

Here is a link to an example (links are dummy): https://1drv.ms/x/s!AuegXLDJ6id1bayz1F0JXSJvMfQ

Also, how can I stop the numbered column A from appearing in the import?

Thanks a ton!

 

[Evan99]

Here's how it looks..

 

[Evan99]

Anyone out there?

 

[fgiron83]

Hi Evan99, I'm having the same problem with the 100 rows limit. Were you able to solve the problem? Thanks for your help!