title: Why do I need to double click a cell for the latest value of my excel document (build in) property?
body: <p>I have an excel document with some macros. These macros are getting my "build in", "custom" and "SharePoint content type"  properties. I am executing these macro functions in 3 cells. </p>
  
  <p>Here are my 3 macro functions:</p>
  
  <p><img src="https://i.stack.imgur.com/PcHJq.png" alt="enter image description here"></p>
  
  <p>The problem is that when these properties are changed, I only see the old value. When I would like to see the new value in a cel, I need to double click on the cell, press on enter, and after this you see the new value of the property.</p>
  
  <p>See here an example.</p>
  
  <p>This is the first value of the title property:</p>
  
  <p><img src="https://i.stack.imgur.com/CaEvU.png" alt="enter image description here"></p>
  
  <p>After this I have changed the title from "This is my title old" to "This is my title new". After this change you still see the old value in the cell:</p>
  
  <p><img src="https://i.stack.imgur.com/UtgFj.png" alt="enter image description here"></p>
  
  <p>Now I am going to force the latest version of this property by double clicking the cell (B2), press on the enter key. And Voila, there is the latest value of my title document property.</p>
  
  <p><img src="https://i.stack.imgur.com/NUpj9.png" alt="enter image description here"></p>
  
  <p>What can I do to avoid these manual forcing the latest version of a document property? I would like to show always the latest version of the document property.</p>