Forum Discussion
Excel 365 Sheet Views are not working
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
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.
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.
- same issue for me
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)
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.
(Please click on the heading for detailed information.)
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the webHave 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