Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a situation where I need to have version number on each document in version controlled document library. Having version number on printed sheet would help to see the validity of document.

I did read following which helped me in setting up label for word document but I need to do same for excel spreadsheet and if possible for Visio diagram. http://stackoverflow.com/questions/508229/how-can-i-include-value-of-sharepoints-version-column-in-a-word-document/590444#590444

share|improve this question
    
Did you try following those steps but instead of using a Word document, using an Excel file? My assumption is the process is probably 99% the same, just wondering if my assumption is wrong. –  shufler Nov 29 '11 at 22:46
1  
I though same initially but With word you get button "quick parts" under insert ribbon, through which you can add document property label. where as with excel there is no button for quick parts. As you have turned on the information management polity for label you do get a label button under insert ribbon in excel but it does not work. –  Digant Nov 30 '11 at 0:27
    
The text section on the insert tab is screaming for a Quick Parts button... Too bad :( –  shufler Nov 30 '11 at 1:38

1 Answer 1

It appears that Quick Parts are not available in Excel, though the rumblings on the webs suggest maybe they should be...

While not the same (but similar), you could set up the document library as suggested in the SE post, and then create a template in the document library that contains the VBA function listed on this page. I haven't tried it myself, but in theory if you use the same property you define in the library, it may work.

Edit: As per Diego Hillesheim's comment the link is broken due to a PHP error. Neither Google nor the Way Back Machine have a cached copy. I should have quoted the relevant section here. :(

share|improve this answer
1  
Built-in document property does not have version as a property field to display. –  Digant Nov 30 '11 at 5:05
1  
The link is broken –  Diego Hillesheim Jun 11 at 11:58

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.