Forum Discussion
Excel 365 Sheet Views are not working
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
PFonseca I have this issue often. Its always a shared file and sheet view works for months until it suddenly doesn't. In my case, I found that merged cells are to blame for this. Someone merged 2 cells in a column and suddenly Excel has no idea how to function.
If you're using Excel on web, you might still get an error even after you have unmerged the cells but when the page reloads it shows you the sheet view you wanted. But I'd open the file in the desktop app instead as it doesn't seem to do this.
Hopefully this helps!- I have a very similar issue. Excel workbook with queries and pivot tables and slicers to create customized reports uses could view and edit in their individual sheet view. This spreadsheet worked during the fall of 2020 but the identical spreadsheet now constantly refreshes the sheet view based on the last user's filter modification. Basically all users have to work with the same (default) sheet view, instead of their personalized sheet view. This eliminates to possibility of multiple users using the spreadsheet independently.
- same issue for me.... did you solve it?
- Same issue her for me - Excel views are simply not working any more. Very frustrating. The old style views were fine, but now they have "modernised them they seem to have broken them 😞
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.
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
Please do not forget, I am a layman when it comes to Excel Web, all information without guarantee ... because I know that I know nothingI 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
