Some people can't open and edit identically shared excel Spreadsheet

David - Spire Travel 0 Reputation points
2023-01-31T09:56:09.09+00:00

Hi, I have an identically copied Spreadsheet that is shared with a number of individuals, for individual editing. Some people can't open the shared item when they press OPEN. I try opening, on a personal email address, and it works perfectly, but they are asked to sign in. When they use their registered email it opens the sheet but they can't edit. All of the settings on each sheet are identical and correct for editing.

What is the reason for this and how can this issue be solved

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,328 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. JOSE IGNACIO HERRERA RUIZ 166 Reputation points
    2023-02-01T10:00:21.84+00:00

    Hi David,

    some clarification questions:

    • are you sharing from your onedrive?
    • all the individuals are external users? could you try with open sharing taht can access only who knows the link?
    0 comments No comments

  2. JOSE IGNACIO HERRERA RUIZ 166 Reputation points
    2023-02-01T10:08:12.8466667+00:00

    Hi David,

    where the file is located? your onedrive?

    are the other users external people of your org?

    did you try to share the file without permissions (public accesss) to only who knows the link?

    https://support.microsoft.com/en-us/office/share-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07

    0 comments No comments