In some cases, when you work with Excel-documents, you’ll stumble upon the Excel-error “Cannot perform this operation. The file has been deleted or someone else has it checked out.” somewhere down the line. Now, there could be a tiny chance that the file you’re working on actually has been deleted or checked out by someone else. But chances are much higher that the error is caused by something else.
There are a few options:
- The user doesn’t have sufficient rights.
- Your Office installation is corrupt.
- Not all SharePoint add-ons are enabled.
- Minor version limit has been reached.
- The DNS client is not (properly) running.
- The database server’s filegroup is full or the disk is run out of free space.
Let’s take a more in depth look at the above named options.
1. The user doesn’t have sufficient rights.
Perhaps needless to say, but the user should have contribute rights to the document at the very least. Reading rights are not sufficient!
However, even if or after you have granted your user the right permissions to the file or the library the file is in, the user could still receive this error due to insufficient permissions. In that case, check if the library uses the managed metadata columns.
If the library has a managed metadata column, it’s possible that the user doesn’t have sufficient rights on a hidden list named TaxonomyHiddenList. To check the permissions of this list, go to the following URL:
In case the user does not have the correct permissions, either grant the user reading permissions to this list or grant all users reading permissions to this list, for example through
NT AUTHORITY\authenticated users or
Everybody. Adding all users will prevent others for possibly getting the same error.
2. Your Office installation is corrupt.
No worry’s, if this is truly the case you can simply fix it by repairing your Office-installation. To do this, hit the Start button on your desktop, type Programs and hit the Enter button. Find Office in the list, select it and click on Change. When setup is done loading select the Repair option and click Continue.
3. Not all SharePoint add-ons are enabled.
It’s always good to check if the required SharePoint add-ons are installed. Assuming you use Internet Explorer, take the following steps to check this. Open IE. Go to Tools (gear) and click on Manage add-ons. Change the filter dropdown to All add-ons and check if the following add-ons are available and enabled:
- SharePoint Export Database Launcher
- SharePoint OpenDocuments Class
- SharePoint Spreadsheet Launcher
- SharePoint Stssync Handler
Most importantly the SharePoint OpenDocuments Class should be enabled for working with Excel. You can find more info about the background of these add-ons here.
4. Minor version limit has been reached.
In case you’re using major and minor (draft) versions in a library, it’s possible that you have ran into the minor version limit of your library. A file can have a maximum of 511 minor versions. In case that limit is reached, you first have to publish a major version.
5. The DNS client is not (properly) running.
This possible solution is given in a TechNet-article and can be executed by following next steps:
- Click Start, click Run, type services.msc, and then click OK.
- In the list of services, click DNS Client.
- Make sure that the Status column displays Started and that the Startup Type column displays Automatic.
- If the service is not set to Started or if the startup type for the DNS Client service is not set to Automatic, follow these steps:
- Right-click DNS Client, and then click Properties.
- In the DNS Client Properties dialog box, click the General tab, and then click Automatic in the Startup type list.
- Click Start, click Apply, and then click OK.
6. The database server’s filegroup is full or the disk is run out of free space.
This possible solution is from the same TechNet-article as the previous possible solution.
For more info, check MSDN.