It's good that there are quick solutions! Not being able to bring the cells into the required order makes your work unnecessarily difficult. When sorting or filtering is no longer possible, you often face a major problem. When you work with a table, it becomes larger and more complex over time. The great strength of Excel is the management of an almost infinite amount of data. Link: XLS files and Office Web EXCEL DOES NOT ALLOW FILTERS OR SORTING This has to be repeated in a file for all sheets that have activated the 'Break preview' view. In the existing XLS files, switch from 'View" data-type="undefined" target="_blank"> 'Break preview' to 'Normal' e view. Save new files only in the new (XLSX) format (because only this can be edited in the browser via OWA). To do this: Open the XLS file and then 'Save as', file type 'Excel workbook (*. The possible workarounds can be seen below.Ĭonvert existing files to the new XLSX format
View> Break preview is activated in one of the data sheets.Ī solution as far as I could research on the internet has not yet been found. The old XLS file type (the problem does not exist with the new XLSX format). The problem can be observed as soon as the following constellation occurs (note the AND links):