• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 441
  • Last Modified:

Sharepoint Document Library: Column showing as "Required" when it is set to "Not Required" in Excel document.

I have a document library which handles an Excel template.

One field in particular - CBU ( a drop-down choice) from the Sharepoint library always shows up as Required in the Document Information Panel, even though it is set to Not Required.

I have tried removing and recreating this column but it refuses to be "Not Required" within the document.

Is there any way to resolve it? I have created another field called Workcentre with the same properties which works fine and is set to Not Required, however, I need to be able to use the CBU field.

Please let me know :)
cbu-field.jpg
column-prop.jpg
0
ultra-it
Asked:
ultra-it
1 Solution
 
pramodsk40Commented:
Try specifying the default value and see if that resolves it...
0
 
ultra-itAuthor Commented:
I have indeed tried specifying this and still does the same - it was taken out to see if it would work :)
0
 
svetayeCommented:
Hello,
I think that you problem is that you don't have any default value in your column so excel can't save the spreadsheet because the value of this column is not one of possible drop down values.
Please try to add some default value to your column like "Please select..." or something else to be an "empty value" of the column.
I hope it helps.
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
tapiwabCommented:
there might be some validation on this field, check carefully
0
 
ultra-itAuthor Commented:
I have checked and rechecked this issue (based on your advice) and it is still unable to resolve.

I have had to bypass this issue with a different field name - I suspect deleting the library and recreating would work.

Not really a solution as such, but worked for me.
0
 
ultra-itAuthor Commented:
Not really a solution, more a work around.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now