How to show Excel doc file TABS in Sharepoint

Copper Contributor

Had a team trying to display tabs in Excel files saved to Sharepoint.

Nothing they tried worked.  After a bit of trial and error, I have a fix.

 

Open Sharepoint, right click on the excel file in question and select open in app. 

 

Danny_Cox_10-1627427039633.png

 

Next, in Excel, right click on one of the tabs and click on “Select All Sheets”

Danny_Cox_6-1627426361356.png

 

Next, right click on any tab and select “Unhide”

 

Danny_Cox_7-1627426545865.png

 

A new window opens allowing you to select which tabs to unhide.

 

Using the mouse and keyboard “Shift” button to highlight the desired tabs to unhide; then click ok..

Danny_Cox_8-1627426691122.png

 

Close Excel, causing a new window to open. When the process completes, excel will close and the file is ready to work as expected in the browser.

Danny_Cox_9-1627426825055.png

 

That's it.

 

Hope this helps.

 

 

1 Reply
Let me know if you find this useful, or need the steps updated...