Sync document properties in SharePoint and Word

 Jul 10, 2014

It’s common to store Word documents in a SharePoint library. If that library has "versioning" turned on, then you may want to display the version number (or other SharePoint metadata columns) in the header or footer of the Word document.

If you create your own columns in the SharePoint library then it is easy to insert that column into the Word document. All you have to do is go to the 'Insert' tab in your Word document, click the 'Quick Parts' button on the far right and select 'Document Property.' The SharePoint column that you created will now be listed as an option here.

Take a look at the example below. In SharePoint, I have created a library and put some files into it. I have also created a metadata column called ‘Policy Type’ and filled it in for each file.

Sync document properties in SharePoint and Word

When I open one of these Word documents, I can insert the ‘Policy Type’ column into the Word file (through the 'Document Property' as advised above) so it can be displayed and printed as part of the document. Here is the result:

Sync document properties in SharePoint and Word

However, if you haven't already noticed, there isn’t an option to choose columns that the SharePoint Library comes with, such as the SharePoint ‘Version’ column. In this next section, I'll explain how to insert the 'Version' column.

SharePoint Libraries have a feature called 'Information Management Policies' and one of the things this can do is to insert a label. We are going to create an Information Management Policy with a label that is equal to the Version column and insert that. To do this, go to your 'Document Library Settings' and under the ''Permissions and Management' list, click on 'Information Management Policy Settings.'

Sync document properties in SharePoint and Word

Then in the next screen, click on 'Document' (or the main content type you are using in the Library) and you will end up in the policy area. Scroll down to the bottom of the page and click the tick box for Labels. 

In the box that says 'Label Format,' type this:

{Version}

If you click on the 'Refresh' button, you'll be able to see what the label looks like & it should look like the below. This is good because it means SharePoint is recognising our code.

Sync document properties in SharePoint and Word

Now we can open a Word document and insert the 'Version' number. Notice in the image below that this time, I am inserting the label in the footer. Repeat the steps from before and navigate to the 'Document Property' list and select 'Label.' The label is now inserted as a field into the document (basically, an update-able piece of text).

Sync document properties in SharePoint and Word

Under the 'Insert' tab, there's now an extra button on the end of the Insert tab called 'Label.' If you use this button, then the label is also inserted but as a graphic object. I prefer the first one (i.e. the text field) because it works better and is easier to format and update. Either way, the label won’t actually show the actual version number until you save the file (and check it in, if needed) back into SharePoint. If you do that then reopen the file, you’ll see the version number. Cool!

Sync document properties in SharePoint and Word

How do your Excel skills stack up?   

Test Now  

About the Author:

Matthew Goodall  

Matthew is a qualified Microsoft Office Specialist, Microsoft Certified Applications Specialist and a Microsoft Certified Trainer with over 11 years of hands-on experience in a training facilitation role. He is one of New Horizons most dynamic instructors who consistently receives high feedback scores from students. Matt enjoys helping students achieve real professional and personal growth through the courses he delivers. He is best known for creating “fans” of students, who regularly request him as an instructor for any future courses they undertake at New Horizons.

Read full bio
top
Back to top