I've entered some text in File>Properties>Summary>Subject an example would be test. I then inserted the field called subject from Insert>Field>Subject and sure enough test appears on the page. However when i change the text in the properties summary area the text does not automatically update on the document instead you have to press F9. Is there anyway to automate this as when two people are sharing the document unless the second user knows to press F9 the document will not reflect the changes made to properties> summary> subject.

I don't know a "standard" way of doing this, but here is a way that works - if you're desperate. Copy and paste this into a module in your document. Then run it once. It will run itself every second thereafter. Any changes you make to any fields will therefore also update every second. Maybe someone else here has a better idea. The other thing you can do is rename it "autorun_open" or whatever that code is (I can never remember!) that makes it runs itself as soon as the workbook is opened. Sub UpdateFields() ActiveDocument.Fields.Update Application.OnTime When:=Now + TimeValue("00:00:01"), _ Name:="UpdateFields" End Sub Hope that helps Tom