SharePoint Document Library: Print Version Number on Excel File

%3CLINGO-SUB%20id%3D%22lingo-sub-667310%22%20slang%3D%22en-US%22%3ESharePoint%20Document%20Library%3A%20Print%20Version%20Number%20on%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-667310%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20version%20control%20enabled%20on%20a%20SharePoint%20document%20library%20and%20I'd%20like%20the%20documents%20in%20the%20library%20(Excel%20files)%20to%20print%20out%20with%20the%20current%20version%20number.%20Is%20there%20a%20way%20to%20do%20this%3F%20If%20not%2C%20is%20this%20being%20considered%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-667310%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-667505%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Document%20Library%3A%20Print%20Version%20Number%20on%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-667505%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F138670%22%20target%3D%22_blank%22%3E%40Chris%20Pritty%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20the%20%3CSTRONG%3EVersion%3C%2FSTRONG%3E%20column%20to%20the%20view.%20Printing%20the%20version%20number%20would%20come%20from%20within%20Excel%20and%20not%20SharePoint.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20946px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117115iE1AEE1A4302332D6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-667612%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Document%20Library%3A%20Print%20Version%20Number%20on%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-667612%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%26nbsp%3BI%20want%20the%20version%20number%20from%20the%20SharePoint%20library%20to%20be%20available%20in%20the%20Excel%20file%20(visible%20on%20the%20Excel%20file%20in%20the%20header%20or%20footer%20when%20printed).%20The%20reason%20for%20this%20is%20so%20you%20can%20identify%20the%20document%20version%20after%20it's%20been%20printed%20off.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHaving%20the%20version%20number%20(or%20revision%20date)%20on%20the%20documents%20is%20ISO%20requirement%20for%20many%20corporations%20and%20SharePoint%20should%20support%20this%20functionality.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-668278%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Document%20Library%3A%20Print%20Version%20Number%20on%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-668278%22%20slang%3D%22en-US%22%3EThat%20is%20not%20a%20sharePoint%20issue%2C%20its%20an%20Excel%20issue.%20Last%20time%20I%20tried%20to%20do%20this%20we%20had%20to%20write%20custom%20code%20to%20get%20that%20kind%20of%20data%20in%20an%20excel%20file%20footer%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-668300%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Document%20Library%3A%20Print%20Version%20Number%20on%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-668300%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1096%22%20target%3D%22_blank%22%3E%40Dean%20Gross%3C%2FA%3E%26nbsp%3BIt's%20a%20%22Microsoft%20Issue%22%20-%20LOL%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMicrosoft%20-%20Please%20make%20this%20happen...%20It's%20HUGE.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-668323%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Document%20Library%3A%20Print%20Version%20Number%20on%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-668323%22%20slang%3D%22en-US%22%3Ethe%20best%20way%20to%20get%20this%20done%20is%20to%20add%20an%20item%20to%20UserVoice%20and%20then%20others%20can%20vote%20on%20it.%20That%20is%20where%20the%20dev%20teams%20go%20to%20review%20requests%20like%20this.%3C%2FLINGO-BODY%3E
Occasional Contributor

I have version control enabled on a SharePoint document library and I'd like the documents in the library (Excel files) to print out with the current version number. Is there a way to do this? If not, is this being considered?

 

Thanks

7 Replies

Hello @Chris Pritty,

 

You can the Version column to the view. Printing the version number would come from within Excel and not SharePoint.

Capture.PNG

 

I hope this helps.

 

Norm

 

@Norman Young I want the version number from the SharePoint library to be available in the Excel file (visible on the Excel file in the header or footer when printed). The reason for this is so you can identify the document version after it's been printed off.

 

Having the version number (or revision date) on the documents is ISO requirement for many corporations and SharePoint should support this functionality.

 

That is not a sharePoint issue, its an Excel issue. Last time I tried to do this we had to write custom code to get that kind of data in an excel file footer

@Dean Gross It's a "Microsoft Issue" - LOL

 

Microsoft - Please make this happen... It's HUGE.

the best way to get this done is to add an item to UserVoice and then others can vote on it. That is where the dev teams go to review requests like this.
Hi Chris,

Did you find a solution to this? I am creating a new document management system in SharePoint that applies automatic numbering when a document is uploaded. For Word files it is easy to add the document and version number in the footer of the file. However, I am struggling to find an answer on how to insert the same to the Excel files.

Hoping you can help.
Regards
Karen