Feedback by UserVoice

 

How can we improve Excel for Windows (Desktop Application)?

← Excel for Windows (Desktop Application)

read only mode

Excel 2016 workbooks open in read only mode from SharePoint and Edit needs to be enabled everytime.

I open and edit the same workbook 100 times every day. I wish that I could open the Excel without clicking the Edit button every single time.

220 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Kimmo shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

53 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Flag as inappropriate

    Way to go Microsloft! everything great till updates...now back to this read-only mode...for the love of God, please stop doing things like this. Whole facility is at a crawl since they cannot edit existing SharePoint docs which they were editing Friday...

  • Jon Carlson commented  ·   ·  Flag as inappropriate

    Also wishing this behavior would be changed. Why doesn't Excel 2016 offer the same real-time collaboration in single-license versions that's available through O365 subscriptions?

    Until this is fixed, the macro suggested in this thread provides a limited-functionality workaround: https://answers.microsoft.com/en-us/msoffice/forum/all/excel-2016-opens-in-read-only-from-sharepoint/9ed0e6df-ac82-428c-997f-deb86e618927

  • Anonymous commented  ·   ·  Flag as inappropriate

    So
    Very
    Annoying!!!
    Lay this on top of working in MS Teams, clicking a file and selecting "Open in Excel" (which should be an allowable default behavior!), which then feels the need to tell me that it is opening my workbook in Excel, and I have to click a button to let it continue, and we have 3 clicks plus mouse movement in order to open a workbook, ready to work.
    This is ridiculous.
    Please fix or provide a registry hack or workaround or something but please stop wasting our time with this Excel nanny.

  • Anonymous commented  ·   ·  Flag as inappropriate

    this is a version issue, not a feature
    i have installed office2016 from 365 subscriptions and partner action packs and found different results.
    at this point i have only one person with this issue but i cant reinstall his system until the end of the month. then i will have no more users with the read only issue.

    check your windows and office versions

    Mine that work are
    Windows 10 Enterprise/Professional
    Version 1803
    OS Build 17134.165
    Microsoft Office 365 Pro Plus Version 1807 Build 10325.20082 click-to-run monthly channel

  • Maaike commented  ·   ·  Flag as inappropriate

    For us this was a solution: save the Excel file to Onedrive. In the settings for Onedrive on your windows taskbar you have a tab Office, here you can uncheck syncing Office. We did this on remote desktop with another account, so my account doesn't have this onedrive setting. From here you can use flow to do what you want with the document.

  • mizzmarkiw commented  ·   ·  Flag as inappropriate

    PLEASE, PLEASE, PLEASE allow Excel documents to open ready to edit. PLEASE REMOVE THIS RIDICULOUS ENHANCEMENT

  • Michael Collins commented  ·   ·  Flag as inappropriate

    This is a **GREAT** enhancement. My users can open Excel without fear of a miss click, miss type, or coffee spill over the keyboard ruining their document due to the auto save feature. I wish there was a specific option to force this in the document library similar to how you can choose Desktop version vs Browser when opening a doc.

    I would prefer that even from a trusted site, when no other user was editing the doc my users would still need to have the choice to edit.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Worst "enhancement" ever! Why would end users want to open files, working in them read only?Please urgently remove this read only default feature!

  • Eoin Sharkey commented  ·   ·  Flag as inappropriate

    A lot of these comments relate to Excel delivered on Office365, and I understand an update released in around July 2017 may have 'fixed' this behaviour.

    At my company, we are not yet ready to embrace SaaS but I did manage to get a trial going with Office 2016 MSI (standalone software). That (MSI) version doesn't get usual features through the channel, but it does get updates (mostly security patches etc), does anyone know if the 'default behaviour' change will ever get included in the MSI updates ?

  • Anonymous commented  ·   ·  Flag as inappropriate

    i suggest that you fire the person who made this change, since they are somehow unaware of the existence of macros which edit other files? they think everyone loves clicking those yellow header buttons? how could this happen. i suspect there was actually some unrelated issue that was fixed by destroying this critical functionality.

  • Trung commented  ·   ·  Flag as inappropriate

    I am unable to withdrawn and update data from local excel database to sharepoint. Please release this "enhancement"

  • Sandi Wong commented  ·   ·  Flag as inappropriate

    I am getting a lot of complaints about this. Please speak to users before coming up with your bright ideas.

  • Anon commented  ·   ·  Flag as inappropriate

    How to make Microsoft Word better.

    1.) Get rid of Read-Only mode.

    2.) Make it free again.

  • Walter commented  ·   ·  Flag as inappropriate

    this is really frustrating, IT had to create a new folder and after that I could write in MY files, it was fine for a while and now I have AGAIN the same issue.. I cannot be creating new folders for the rest of my file.. please FIX it...

← Previous 1 3

Excel for Windows (Desktop Application): Collaboration and Sharing

Categories

Feedback and Knowledge Base

(thinking…)