Excel File Saved on OneDrive, Password Protected, Won't Let Me Get in Write Mode When Someone Else in READ

jpd 0 Reputation points
2024-03-07T20:46:43.5566667+00:00

Hi,

I have a password protected file saved on One-Drive. If someone else in my organization is in the file in READ-ONLY mode (they are NOT co-authoring) it won't allow me to get in the file in Write mode. This does not happen on a normal network drive, only on OneDrive. Is there some setting I need to have applied to allow this? I want to reiterate, the other person accessing the file is in READ mode and doesn't even have the password to get the file in Write mode. Should I be able to access it in Write mode still?

OneDrive Management
OneDrive Management
OneDrive: A Microsoft file hosting and synchronization service.Management: The act or process of organizing, handling, directing or controlling something.
1,136 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,645 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 22,011 Reputation points Microsoft Vendor
    2024-03-08T07:28:40.7033333+00:00

    Hi,

    Did you open the file in browser?

    Did this problem appear in all Excel protected Workbooks?

    How did you protect the Workbook? Protect Workbook or Worksheet?

    If you protect the Worksheets but not Workbook, Worksheets which are protected can only be viewed in Excel for the web. This is by design behavior for Excel.

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If my understanding is incorrect, please provide more information about your problem, I'm glad to help you.

    If the response is helpful, please click "Accept Answer" and upvote it.

    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