How do I get the SharePoint document Version number into an Excel file

New Contributor

As the subject states, I am looking for a way to insert the current document version into the actual Excel file itself.

I have content management/versioning enabled so that is up and running.



I would like to have the "2.0" in the actual TEST.xlsm somehow.

2 Replies
best response confirmed by Niklas_E (New Contributor)
So in Excel there isn't a quick part as same as in Word but you can create a function in Excel that get's the Custom SharePoint value
Excellent, thanks! It worked perfectly :)