Sharing Sheet with other users
Because the APIKEY is personal and you agreed not to share the API data with others we check that the Sheet is not Shared.
If you get this warning you need to remove any shared users or you need to set Sheet to Restricted.
Remove all Shared users.
Only Restricted Sheet is allowed.
Set Sheet to Restricted.
When settings is Saved then try to Refresh the Sheet again.
You should now get all API data.