Opening .XLS files, displays as ReadOnly

Chris Stephens 6 Reputation points
2022-04-25T22:16:56.153+00:00

Users need to Share .XLS files with external users

some users are not on latest excel so users use .XLS rather than .XLSX
Problem is these open as READ ONLY - is this NORNAL / Expected behaviour?

Users can edit the file but need additional clicks!

Some users have had issue with Opening the file in Excel and saving
sometime file does not save the updated version
One user added thosand of rows > saved
and found later the file had not saved! LOST a LOT of Work

other users have said when opened in Excel the files are weeks old !

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,061 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Xuyan Ding - MSFT 7,561 Reputation points
    2022-04-26T10:03:33.023+00:00

    Hi @Chris Stephens

    Displaying read-only requires an extra click, probably because the file is in protected view. Exiting "protected view" can simply enable editing in the message bar, which is normal/expected behavior.

    Per my test, using online co-editing should not fail to save, because the files edited in the browser are automatically saved by the system. According to your description, external users may edit shared files through ‘open in app’, which may cause upload failure due to multiple editing. I tried it and got a notification that the upload failed in the image below, which may be ignored by the user. So I recommend ‘open in browser’ to edit shared files with multiple people, which will reduce the failure of saving due to uploading.
    196571-screenshot-2022-04-26-162326.png


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Chris Stephens 6 Reputation points
    2022-04-26T17:24:11.03+00:00

    I notice the file is .xlsx & sharedonline for co-editing
    This is not the use case

    Unfortunatly, when I say SHARED - the files PHYSICALLY are emailed to various users (hence the use of .xls)
    and users have various version of office and most users are OFF Line
    (Data is collected in the field, in some cases quite literally)