sikadmin
asked on
How to insert SharePoint Document Properties into Excel cells
Hello,
is there a way to insert SharePoint online document properties in regular excel application (office 2010)
for example i want to see the SharePoint version of the document
In Word you can do this with Insert > Quick Parts > Document Property.
but i cant see it in excel
is there a way to insert SharePoint online document properties in regular excel application (office 2010)
for example i want to see the SharePoint version of the document
In Word you can do this with Insert > Quick Parts > Document Property.
but i cant see it in excel
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
AFAIK it would not be possible to get the OOTB version information from SharePoint.
AFAIK it would not be possible to get the OOTB version information from SharePoint.
ASKER
Sorry,
but i didnt follow you trough
what is : AFAIK and OOTB
but i didnt follow you trough
what is : AFAIK and OOTB
First, the link in comment 38972747 is relevant. The code posted there is VBA and runs in your Excel file. What flavour of SharePoint hosting you are using is not relevant.
AFAIK = As Far As I Kow
OOTB = Out of the Box.
AFAIK = As Far As I Kow
OOTB = Out of the Box.
ASKER
in excel 2010 i can see the properties from my sahrepoint in the info tab in the right hand side
now the qeustion is how to display those in an excel cell in one of the sheets ?
is there a OOTB function for this ?
now the qeustion is how to display those in an excel cell in one of the sheets ?
is there a OOTB function for this ?
afaik == as far as i know
ootb == out of the box
ootb == out of the box
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i need it to work with SAHREPOINT ONLINE, not the regular SharePoint server