You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can we hide a specific sheet in the excel output for some users?

Received Response
41
Views
2
Comments

Content (required):

We have an excel report which contains 2 tabs where 1st sheet contains the data dump and 2nd sheet is the actual report which is based on the 1st sheet data.

we have a requirement that 1st sheet should be only visible for those who have admin role. we cannot use hide function in the sheet, snice non admins can unhide the 1st sheet and view the data.

Is there any approach ?

Please let me know if there is any other approach.

Version (include the version you are using, if applicable):

23A

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!