Is it possible to have live links on a read-only page?
I created a Report in which several other sheets report data into. It also creates a link to the sheet where each line item came from. Which is very useful.
Because I need to make this report available to over 250 people I created a "Full" read-only link, which works well except for the fact that the links to the other sheets do not work. They only seem work if you open the sheet as a collaborator. I don't really have to want to share the sheet every time someone new wants to view it. I work for a large company and I would have to manage the access constantly.
Is there a way to have live links on a read-only sheet?