Excel 365 Sheet Views are not working

[PFonseca]

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

[#2]

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

[#3]

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

[#4]

@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.

[#5]

@NikolinoDE I am having the same issue with these views not working after a day or two, even if I leave the file open, and I am using XLSX format. Filters usually disappear overnight. I leave the file open all the time and sometimes when I come back, the filters are simply not showing and the sheet views stop working. Even if I turn filters back on, all the sheet views no longer function. This is extremely annoying. I wonder if it has something to do with the fact that some people are opening the file through Teams. I have tried to break it by opening in Teams myself, but it doesn't seem to have an immediate effect. My guess is that a series of things together is causing this but I can't figure out what. Probably the solution would be to move this to a SharePoint list.   

[#6]

@Dom_Correa 

IF EXCEL DOES NOT ALLOW FILTERS OR SORTING

OFFICE

The great strength of Excel is the management of an almost infinite amount of data. When you work with a table, it becomes larger and more complex over time. When sorting or filtering is no longer possible, you often face a major problem. Not being able to bring the cells into the required order makes your work unnecessarily difficult. It's good that there are quick solutions!

In such a case, the Sort and Filter button in Excel is grayed out and cannot be selected when certain cells are selected. The way via right mouse button on the cells to be sorted> Sort does not work either. The cause here is usually the application of a table template to some cells, which is more or less confusing to Excel.

The first solution is to remove the table template: highlight the affected cells and remove any formatting, coloring and backgrounds. This allows you to analyze step-by-step what exactly is responsible for the error, but it is also time-consuming.

The faster way: Select the complete table by clicking on the small triangle between the row and column names. Then right-click in the selection and click Copy. Then create a new, empty worksheet and click in the first cell.

By pressing the right mouse button and inserting content, you now get a variety of possible insert types. Select values ​​and source formatting here. The table looks like before, only suddenly the filter and sort button can be used again!

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

[#7]

@NikolinoDE thanks for the response. I am able to get filters working again, the issue is the custom sheet views (View Tab >> Sheet View area) stop working. The table filters do get turned off as well, but clicking filter turns that back on. Even so, while the custom sheet views are present, they do nothing. This spreadsheet is reviewed with many people on a call each day and it would be nice to be able to simple click on a sheet view to get the table in order for the review. Instead I have to go into Sort & Filter >> Custom sort, filter a column here and there, etc. I was excited when I saw you could save a sheet view, but after some period of time it simply stops working. Frustrating. 

[#8]

@Dom_Correa 

Sheet Views in Excel

(Please click on the heading for detailed information.)

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web

Have you ever collaborated with someone else in a worksheet, looking at a large data set, and suddenly the table shrinks and you’re unable to finish your work? It's pretty disruptive isn't it?

Sheet views are an innovative way of letting you create customized views in an Excel worksheet without being disrupted by others. For instance, you can set up a filter to display only the records that are important to you, without being affected by others sorting and filtering in the document. You can even set up multiple sheet views on the same worksheet. Any cell-level edits you make will automatically be saved with the workbook regardless of which view you’re in.

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

[#9]

I am using sheet views. That's what is breaking. They work for a while, then, typically overnight when the spreadsheet is left open, filtering gets turned off, and none of the sheet views work, even after turning filtering back on. This is the issue I am facing.

[#10]

@NikolinoDE Hi, I know you are trying to help here but please be mindful of the thread's topic before replying. The issue the OP was asking about is "Excel 365 Sheet Views are not working" and your reply is out of context of the original issue.  

[#11]

@nagaden 

Of course, it is clear to me that Excel is constantly evolving.

I also realize that I am not the best person to give a 100% answer (I pointed this out at the beginning).

I also realize that it took this user, months to get a response.

 It is also clear to me that if I give an answer in an area that I have very little idea, I have to be very careful with my wording and pass on the information as far as possible from links.

My principle, everyone has the right to an answer, even if it is not 100%.

Better a vague answer than none at all.

My principle, rather to show a community member that you are here, even if you are not 100% the right one, than that the user feels left alone in the vast universe of Microsoft.

My principle is that what you feel is not a fact, but if you ignore it, it becomes a fact.

To end, if you ask me or ask me not to answer something that is not 1000% correct, then I can only answer ... NO, I will answer even if im not 100% sure.

At the same time you would have to delete 80% of the messages because they are not 100% correct.

I haven't seen in any chat forum until now that the Pareto principle has been applied.

Anyway that's just my humble opinion, but who am I that I have the infallible and am not wrong?

Thanks for your time and understanding.

Nikolino

[#12]

@PFonseca I know it's an old post but I was struggling with the same case. Out of the blue, I thought, what if I create at least one Sheet View opening the EXCEL file via EXCEL WEB APP. This did the trick. I created one Custom Sheet View online. Then I tested going back and forth from the DEFAULT to the CUSTOM view. Everything was working like a charm. Then I created from my EXCEL Desktop APP a 2nd CUSTOM view and start going back and forth from the DEFAULT to CUSTOM1 and then CUSTOM2 and then randomly from one to the other. The response was as should.

Hope that helps.