Reports and Source Sheets
I have a client that is wanting to have a report to pull from multiple sheets and share that on a Dashboard. This is done but I need to share the source sheets.
- I am trying to no share the source sheet to users
- In the reports the Sheet name column is a hyper link to the source sheet, however I don't want users to have access to the source sheets and be able to edit it.
- If I don't share the source sheet the users can't see the data in the report.
Is there a way to show the sheet name column and not have it as a hyper link? or do I need to share all the source sheets and lock down all of my source sheets.
I have over 50 source sheets to lock down.
Hopefully this makes sense and there are some suggestions I can get to have this working.