Have you found a way to expand the search query in Excel version to cover a wider range and more than the default 500?

I keep going to the blob storage and just downloading everything instead. The 500 records is very limiting in the Excel version and does not seem to update past it when you edit the options or the query strings.