title: VBA unable to fetch the content type properties from Sharepoint
body: <p>I have my SharePoint connected to my onedrive and use the following piece of code to save the file in the onedrive folders (Which in turn syncs to my Sharepoint) and update the content type properties.</p>
  <p>The file gets saved in sharepoint but I am getting the following error when the second line of code is about to run - This document must contain content type properties - Run time error - 2147216381(80041403).</p>
  <p>Upon investigation, I noticed that the SharePoint properties which should have been fetched by default is not getting fetched (Screenprint for reference)</p>
  <pre><code>ActiveWorkbook.SaveAs Filename:=&quot;C:\Users\meetrk85\OneDrive folder\Documents\ONE.xlsx&quot;
  ActiveWorkbook.ContentTypeProperties(&quot;Approval Status&quot;).Value = &quot;Uploaded&quot;
  </code></pre>
  <p>However, if I manually save the file to the said folder it does fetch the properties.</p>
  <p><a href="https://i.stack.imgur.com/DPPB3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DPPB3.png" alt="enter image description here" /></a></p>
  <p>PS: This is a duplicate of my query raised with no luck 6 days ago hence have rasied it afresh
  <a href="https://stackoverflow.com/questions/63645501/this-document-must-contain-content-type-properties-run-time-error-2147216381">This document must contain content type properties - Run time error - 2147216381(80041403)</a></p>