Forum Discussion

cheeseontoast101's avatar
cheeseontoast101
Copper Contributor
Jun 06, 2022

Read only fix

Hi

I've uploaded some workbooks to one drive. These workbooks are linked and will be opened up on desktop through excel online as it has spin buttons and a refresh button powered through VBA.

 

I've shared them with a colleague but she can only open it up as read only, I also don't see her in the sheets. 

 

What am I doing wrong? I really need this to be functional. We have the full version of office 365.

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    cheeseontoast101 

    SharePoint files open as read-only

    At times, you may find that when you open files from SharePoint or OneDrive for Business they open in read-only mode. More informations in the upper link.

     

    Reset OneDrive

    Resetting Microsoft OneDrive can sometimes resolve sync issues and resets all OneDrive settings. OneDrive will perform a full sync after the reset.

    If you work with the "Regedit".

    Keyboard shortcuts (Windows + R) open the Run window, then type: regedit
    Find and delete OneDrive folders.
    You can find it in this path:
    HKEY_CURRENT_USER\Software\Microsoft\OneDrive
    Expand the Microsoft folder, click the "arrow", inside you will see the OneDrive folder, "right click" over the OneDrive folder and delete all.
    This process only removes the OneDrive configuration, the data is fine.

     

    additional info:

    OneDrive release notes

    This article contains details of the latest OneDrive releases for Windows, Mac, Android, iOS, web and the Windows Store app. Release notes are included only for builds that reach Production.

     

    Hope I could help you with these information / links.

     

    NikolinoDE

    I know I don't know anything (Socrates)

     

Resources