I'd like to restrict unauthorized users to refresh/see queries and provide them with only query output. The template will be used in a weekly basis so deleting queries are not a good option. Is there a way to grant permission to 'need to know' basis and only users with permission can refresh/ see queries?
Thanks, L
Hi Luna,
You can 'Protect Workbook' to prevent access to the Query Editor, however they can still Refresh the query if they know how.
Does it matter if they can Refresh? Presumably it won't make any difference unless they're accessing a live database.
Mynda
Ideally I'd like only authorized users to be able to refresh the query. There were times that the queries were refreshed by others before finalizing the output, which I need to avoid.
Thanks, L
In that case, move the source data to a folder they don't have access to. If they refresh the query it'll return an error. Make sure they can only open the file as 'Read Only'. If they refresh, they can simply close the file and re-open it to restore it. They'll only do it once 🙂
Mynda
Aha!! Thank you, Mynda.
