Just make sure that whatever sheet you’re including for sharing has permissions set up so anyone with the link can view.
The not being able to click could have something to do with our community trying to protect against malicious links if the person doesn’t have a high enough trust level.