Because you are new to the forum, please allow me to explain something about the expectations that I and other volunteers have regarding your I see that you are working for Microsoft and are a Moderator. We can import data from this link more than 100 rows.ĭisclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.īest Gloria - Welcome to the support forum for Excel. ![]() It may be a problem which is related with Google document because when I create a web query which links to some other links, all the rows more than 100 return in Excel correctly. Query…> Choose the iqy file and press get data. iqy> In Excel Data menu bar> Get external data> Run web ![]() ![]() The method we using to create a web query: Copy the link to a word document> Save as plain text> MS-DOS> Save to desktop> Right click the file> Get info> Change the file extension to. We create a web query in Excel 2016 for Mac and get data from the link you provided and the result is the same as you: Only import the first 100 rows into the excel file.Īlso, when we create a new worksheet in Google Drive and import the data into query, the result is the same.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |