Hi,
im trying to import data from a google spreadsheet.
The source does not require login.
Sheet > External Data finds the table and imports data, but only first 100 rows.
Edit > Edit links does not offer more insight or settings.
Tools > Options > Security > Macro Security > Trusted source has the correct file location.
The source has like 10k rows and 7 columns.
Why do i get only 100 rows? And how do i fix this?
Thank you
Please edit your question and add a link to the source.
Better download the entire file.
Tried various things. But the function to import data from external link just cant do it.
And there is also the issue of “The link could not be updated.”.
It only works once.
As long as you don’t provide the link no one can inspect and you can’t be helped.