Share via

Excel Workbook in View only mode only shows a specific Sheet. To view all sheets need to switch to Edit?

Anonymous
2024-07-18T17:34:22+00:00

Hi All,

Well wishes!

Thanks for viewing this post!!

I inherited an Excel sheet "Phone List" - Organizational Phone book with the locals & names/designation of all employees.

The way this WB is created - when you are in a view only mode, you can see the Final Template(the end template to display all the employees/locals the way we want)

But when you are in Edit mode - Only then you can see the reference sheets that this Final Template is based on and make any edits.

I created a new sheet 'ByDepartment' - which basically have a drop down to select/view Employees by department. It also refers to these reference sheets.

I want to make it so that the end user can also see that new ByDepartment sheet along with the Final template. But there seems to be no settings for that?

Then I am wondering how did the previous user made it in the way so that the Reference sheets were hidden?

Hope this makes sense...

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2024-07-22T19:39:24+00:00

    Go to File > Info > Browser View Options > Under “Show”, Choose desired Sheets, Entire Workbook, or Items in the Workbook.

    Hope this helps.

    Cheers.

    2 people found this answer helpful.
    0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-07-19T16:16:14+00:00

    Is it possible to share a test file to reproduce your issue?

    For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.

    *Please make sure you have removed any sensitive or private information in the sample file before uploading.

    0 comments
  2. Anonymous
    2024-07-19T03:30:18+00:00

    Hide reference sheet first.

    Then protect structure of that workbook.

    0 comments
  3. Anonymous
    2024-07-19T15:58:44+00:00

    Thanks!

    Did exactly what you said but still the same issue - Only 'Final Template' is visible to the user that have viewing rights. But not the 'ByDepartment'.

    One more thing -

    If I copy the link to that specific sheet that I want the user to see by doing the below & share that to user.

    They see this error -

    0 comments
  4. Anonymous
    2024-07-19T16:06:56+00:00

    Also to add to above -

    Just noticed that this is the issue when opening the file in the Excel Web. If the user opens the file in the local Excel App, it behaves the way we want it to behave. Shouldn't Web & App have the same view?

    But the issue is, all users receive the link to this sheet & would always open it on the web & never the Excel app... So still need to resolve this.

    0 comments