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.
Even if you never share a sheet you can get this warning. If this happens you can try to refresh the value that check if the sheet is shared.
- Set restricted to Anyone with the link and press Refresh.
- Then change back to restricted and press Refresh.
This should update the value and remove the warning.