Share via

SharePoint Spreadsheet not being able to edit when given a direct access for edit

Anonymous
2021-03-31T02:25:59+00:00

Hi there, 

I'm an IT Technician and I have been working with a client who has an issue editing their spreadsheet via live edit thru SharePoint OneDrive, even though direct access for edit permission is given to them by the owner of the .xls file and this only happens for that particular file. They were successfully able to edit for a test file I have created within the owner's OneDrive/SharePoint profile. When the file is opened, it only comes up in view mode and does not allow editing. Is this something is fixable? I'm little exhausted working on this.

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-03-31T05:40:11+00:00

    Hi Khim Ba Hadur,

    I go through your post carefully and as per your description, it seems issue happen to specific Excel file and get a “Read-only” message with edit permission.

    I just tested from my side via live edit in SharePoint online with edit permission and I cannot edit Excel workbook. See image below for your reference:

    As you mentioned “.xls file” did you change the format to Excel Workbook (*.xlsx)?

    As you mention other test file they can edit, I think the problem could be related to your permission to this Excel file. If you don’t mind, could you please double confirm file permission with me?  you can let the SharePoint site owner to check your account permission in this file. The site owner can right click on the Excel file in SharePoint and click Detail to open detail pane. In detail pane, click Manage access > Advanced to open the file permission windows > Click Check permission to find out your account permission of this file.

    Make sure you account have “Edit” permission to this file so that your account can edit the file with edit permission.

     

    To let us help you, could you please share a screenshot when you open shared Excel file with Edit permission.

    I appreciate your patience and understanding.

    Best Regards

    Waqas Muhammad

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2021-04-02T09:33:49+00:00

    Hi Khim Ba Hadur,

    Feel free to post back if you need further assistance.

    Best Regards,

    Waqas Muhammad

    0 comments