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-19T17:26:05+00:00

    Sure I made a test file. The only change from the original is the actual data to protect the PII.

    Phone List Test.xlsx

    In viewing, you will see the 'Final Template' only & in edit you will see the 'ByDepartment' also appear.

    The workbook is protected with reference & update sheets hidden as you suggested. Password: Pass

    Really appreciate your time!!

    0 comments
  2. Anonymous
    2024-07-19T17:48:11+00:00

    I haven't met such issue. I'd suggest you raise it to Microsoft.

    Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.

    Get support - Microsoft 365 admin | Microsoft Learn

    About how to find the admin in your organization, you can refer to How do I find my Office 365 admin

    0 comments
  3. Anonymous
    2024-07-29T13:47:51+00:00

    Thanks Followed this and found answer through the support....

    0 comments