There is an issue with binding the named ranges in a spreadsheet with the metadata on the server. Adding some VBA script can overcome this.
Dim WB As Workbook
Set WB = ThisWorkbook
For Each Prop In WB.ContentTypeProperties
If Prop.Name = "Project Lead Finance" Then
Prop.Value = Range("A1").Value