07-31-2020 09:47 AM
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
10-16-2020 07:47 AM
@PFonseca Hi, I was wondering if you figured out how to fix this? I am having the same problem. Thank you
10-16-2020 07:56 AM
@Rolke I haven't found a solution, the team is just using the default view.
10-16-2020 08:05 AM
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.