Excel 365 Sheet Views are not working

%3CLINGO-SUB%20id%3D%22lingo-sub-1558950%22%20slang%3D%22en-US%22%3EExcel%20365%20Sheet%20Views%20are%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1558950%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%207%20different%20Sheet%20views%20in%20a%20shared%20document%2C%20they%20were%20working%20fine%20until%20about%20a%20month%20ago.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20then%20I%20have%20tried%20everything%2C%20I%20deleted%20them%2C%20created%20them%20again%20and%20they%20don't%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20create%20them%20they%20look%20fine%20but%20once%20my%20collaborators%20enter%20to%20work%20on%20the%20spreadsheet%20all%20the%20views%20start%20showing%20the%20default%20view.%20The%20sheet%20has%20the%20black%20border%20and%20the%20eye%20in%20the%20tab.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20solve%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1558950%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I have 7 different Sheet views in a shared document, they were working fine until about a month ago.

 

Since then I have tried everything, I deleted them, created them again and they don't work.

 

When I create them they look fine but once my collaborators enter to work on the spreadsheet all the views start showing the default view. The sheet has the black border and the eye in the tab.

 

How can I solve this

3 Replies

@PFonseca Hi, I was wondering if you figured out how to fix this? I am having the same problem. Thank you

@Rolke I haven't found a solution, the team is just using the default view. 

@PFonseca 

 

Some XLS files cannot be viewed in OWA

The problem can be observed as soon as the following constellation occurs (note the AND links):

    The old XLS file type (the problem does not exist with the new XLSX format).

        AND

    View> Break preview is activated in one of the data sheets.

        AND

    SharePoint or OWA is used for viewing.

A solution as far as I could research on the internet has not yet been found.

The possible workarounds can be seen below.

 

Workaround 1:

Convert existing files to the new XLSX format

To do this: Open the XLS file and then "Save as", file type "Excel workbook (* .xlsx)".

Save new files only in the new (XLSX) format (because only this can be edited in the browser via OWA).

 

Workaround 2:

In the existing XLS files, switch from "View"> "Break preview" to "Normal" e view.

Or toggle in the status bar of Excel

This has to be repeated in a file for all sheets that have activated the "Break preview" view.

Then save (and upload) the file.

 

Link: XLS files and Office Web Apps

https://social.technet.microsoft.com/Forums/azure/en-US/95c1e237-bcf0-4c15-ae2e-d96a019289df/xls-fil...

 

Please do not forget, I am a layman when it comes to Excel Web, all information without guarantee ... because I know that I know nothing
 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.