Error "To save to server, correct the invalid missing required properties"

Question

Hi Everyone,

The problem is like "To save to server, correct the invalid missing required properties" once open any office document with office application from specific document library. I checked properties of document and "Required" column of list but nothing related with that.
Environment:
SharePoint 2013
MS Office 2016

What are possible causes and solutions of this issue?

Thanks.

Answer 1

Okay, I've found the solution, here it is the explanation;

When I try to look column type and information of Document via "Library Settings" or "SharePoint Designer" I could see only two column type information showed that are optional. Thus I decided to write magic PS script in order to retrieve all type and information of column.

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
$SiteURL="https://xxx.xxx/xx/xx"
$ListName="XXX List"

$web = Get-SPWeb $SiteURL
$list = $web.Lists.TryGetList($ListName)
$list.Fields | ?{$_.Required -eq "True"} | select Title,Required

Once run this script, I noticed that there is a column which does not show in "Library Settings" like "RoutingRuleExternal". I decided to set "Required" property as "False" instead of delete the field, in any case.

$ColumnName = "RoutingRuleExternal"
$column = $list.Fields[$ColumnName]
$column.Hidden = $false
$column.ReadOnlyField = $false
$column.AllowDeletion = $true
$column.Required = $false
$column.Sealed = $false
$column.Update()

Finally, try to edit documents with office application after refresh the page and happiness!

Thank you all for great effort.

Answer 2

This link gives you a simpler way to do it through the interface: https://lydonsolutions.com/2017/04/21/configure-required-fields-sharepoint/

Essentially, for some reason Microsoft has seemingly made the Notes field required by default - check any libraries where you are getting this issue and you can just untick the required checkbox within the relevant (in this case, Notes) field.

Answer 3

does this document library uses custom content types? You may check that in Doclib settings > Advances settings > Allow management of content types - after that content types will be shown in Doclib settings. These content types may have required fields - may be one of these fields cause this problem.

Answer 4

Hi, @Erdem Ayyildiz ,

Have you go to library settings and check all available columns? As you mention that only documents in a certain document library has this issue, will the same error occur if you upload a new file into this library?

Also you can go to the File>info in office app, use the document inspector to remove the information and test whether the issue remains. Also, have you tried to edit the SharePoint properties in office?

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.