Possible solution: “Sorry, something went wrong. The file is locked for exclusive use by…”

I recently ran into the following error when someone tried to edit a shared Excel file from OneDrive (we’re running SharePoint Server 2016).

“Sorry, something went wrong. The file {address} is locked for exclusive use by {name}.”

Troubleshooting

The user in question, who had it “locked for use,” had the file open in Excel (client, not online) when their computer unexpectedly shut down. This locked others from editing the file. The first few things you should try (stop if one of the steps fixes the issue):

  1. If the user still has it open, have them save and close out. If it really was checked out, check it in with their account.
  2. Make sure the user who has it locked has closed all office apps (Task Manager is a good way to see if anything is running in the background)
  3. Have that user restart their machine used to edit the file in the first place for good measure
  4. You can try waiting a day to see if the lock lifts overnight or after a few hours.

What worked for me

Now that you’ve confirmed the individual who had the file locked can’t really have it open or locked, you can try the solution that worked for me. At the bottom of this post, I’ve listed more ideas I tried that might work for you.

  1. Open the user’s OneDrive in SharePoint Designer (the address may resemble https://mysites.COMPANY.org/personal/USERNAME)
  2. Navigate via “All Files” via the left nav to the file in question. It probably has a padlock icon on it.
  3. Right-click the file name and select “Edit File in Advanced Mode”
  4. Save the file in SharePoint Designer.

I can’t explain why this worked, I know it’s completely illogical, but it worked.

Here’s a thread on SharePoint’s user voice regarding this error.

What might work for you

Here are some things you can try that were not successful for me (but might work for you):

  • I tried copying the file and deleting the original but could not delete it (in browser, PowerShell, or SharePoint Designer)
  • I tried this PowerShell solution and it told me who had it “checked out,” and when it would expire which was helpful, but it was unable to release the lock
    • P.S. I waited for the expiration, but it renewed itself
  • I tried checking it in via browser and SharePoint Designer (because it appeared checked out) but got a message saying it wasn’t
    Click to enlarge
  • From the owner’s OneDrive (where the file was stored/created) I disabled check-out requirement via Site Contents –> Library Settings –> Versioning settings
    Click to enlarge

Increasing MySite OneDrive for Business Storage

I recently ran into the following error message when using OneDrive for Business via MySites (on-prem 2016).

“No free space. Your site is out of storage space and changes can’t be saved…”

The recommendation is to empty your recycle bin, but the recycle bin is probably empty.

The default storage limit for MySites is set to 100 MB (which doesn’t go so far these days).

If you already have a bunch of personal sites created, it’s not as easy as tweaking the quota template. You will need to update the quota template for future sites, then reset all existing sites to use the updated template as well.

Update the Quota Template

Learn more on quota templates: Create, edit, and delete quota templates in SharePoint Server

Set existing sites to use updated template

Now that you’ve set the storage quota template for future sites, we need to update pre-existing sites to adopt this new storage limit. We’ll need to do this via PowerShell.

  1. Remote connect to a SharePoint server
  2. Open SharePoint 2013/2016 Management Shell as administrator (right-click, Run as Administrator)
  3. Run the following script, replacing the web app address with your own, and the template name if different from Personal Site
    $SPWebApp = Get-SPWebApplication https://mysites.MYORG.org
    
    foreach ($SPSite in $SPWebApp.Sites)
    {
        if ($SPSite -ne $null)
        {
            Set-SPSite -Identity $SPSite.url -QuotaTemplate "Personal Site"
            $SPSite.Dispose()
        }
    }

And that’s it! Once that has run successfully, all of your MySites should now have the new limit in place.

Collab365 24-hr Global Conference Recap

DNoObCMUQAARlYN
Baxter joined me for several sessions. He’s new to SharePoint, but eager to learn.

The 24-hr Collab365 Global Conference has come to an end. This event is so well done (kudos to Mark Jones & co.), and was the second year I have been able to attend. I live-tweeted the sessions I attended for the majority of the conference and have shared some highlights below. Also, every session is recorded and will be made available here:

https://collab365.community/

Highlights below include:

  • Adoption & Champions
  • Roadmap, Releases & Rollout
  • Cognitive Search & Ease of Use
  • Analytics

Read my summary of the sessions I attended on Collab365’s site. You can also view tweets from all attendees and speakers tagged #Collab365 here.

Adoption & Champions

Change

Intranets

 Growth

When is Yammer appropriate?

 Which tool/group should I pick?

Roadmap, Releases and Rollout

 Custom, modern site themes!

 Attention view!

Targeted Release!

SharePoint Migration Tool!

 Save things for later in mobile!

OneDrive “Shared With Me” Grouped by Owner!

 Customize the “new item” form with PowerApps!

Staying up-to-date

 PowerApps

 Cognitive Search & Ease of Use

OCR & Indexing

Bringing Services Together

 Reducing Barriers to Usability

Analytics

Admin Center

 PowerApps

See all tweets tagged #Collab365 here.

OneDrive and SharePoint sync issue: “You now have two copies of a file; we couldn’t merge the changes in [filename]” appended with computer name

couldntmergechanges

If you’ve seen a similar notification, I empathize with your pain. I don’t know that there is one solution to this problem, either, so I’m going to share a number of them we’ve used and hope that one (or all) of them will help you.

Basically a file is added through file explorer (a cloud library in OneDrive or SharePoint being synced locally to your computer) but then after a moment a notification appears which says “You now have two copies of a file; we couldn’t merge the changes in [filename]” and then the filename is appended with your computer name again and again until eventually the filename is too long and is harder to delete. Let’s not get to that point.

Continue reading “OneDrive and SharePoint sync issue: “You now have two copies of a file; we couldn’t merge the changes in [filename]” appended with computer name”

“Edit in Word” (or Excel) not opening document in Office 365, or “Read-Only” status upon opening and trying to save changes

When working in Office 365 or SharePoint and you open a document for editing, you get two choices. Edit in Word (or Excel) or Edit in Browser. Editing in browser is typically a safe route but it doesn’t give you full functionality like the clients will.

The issue I’m discussing here is when a user tries to edit a document from SharePoint using the client (not Edit in Browser) the client opens to a blank, gray background (no document) or doesn’t open at all. This is likely an account conflict in syncing or accessing.

In other cases, the document may open, but as read-only. If that’s the case, it’s likely permissions-related. You might first check the user’s specific permissions in SharePoint. Sometimes because of broken (not inherited) permissions, or partial access to a site, users are able to edit in browser, but not in the client. If this is your situation, it could well be the cause.

Hopefully this is a simple fix for you, but as it’s become clear to me a number of times with this issue it can be quite complicated. I have a couple fixes, though the second is less ideal. If anyone else has run into this and would like to offer their experience, please do so in the comments.

Continue reading ““Edit in Word” (or Excel) not opening document in Office 365, or “Read-Only” status upon opening and trying to save changes”