98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Digital Signatures - How to confirm they are genuine
Digital Signatures - How to confirm they are genuine
Resolved · Medium Priority · Version 2016
Andrew has attended:
Excel Intermediate course
Excel Advanced course
Digital Signatures - How to confirm they are genuine
I am putting together a requisition form using Microsoft Excel. The form requires certain people sign it to confirm that the requisition request has the proper approvals. If I add a digital signature line, how can I be sure that the signature is authentic? I understand that this can be achieved through digital certificates.
The form needs to be in excel since it has some large drop down menus but in theory people could convert it to a pdf before getting it signed, if that would be easier.
RE: Digital Signatures - How to confirm they are genuine
Hi Andrew
Thanks for your question.
When someone adds their digital signature to an Excel document, Microsoft automatically creates a signing certificate which proves identity.
To view the signing certificate in a document which has been sent to you - double click on the signature, then click the View button. Here you can see the unique certificate code, and date and time stamp.
Microsoft provides the following assurances with its digital signatures:
Authenticity - The signer is confirmed as the signer.
Integrity - The content has not been changed or tampered with since it was digitally signed.
Non-repudiation - Proves to all parties the origin of the signed content. Repudiation refers to the act of a signer denying any association with the signed content.
Notarization - Signatures in Microsoft Word, Microsoft Excel, or Microsoft PowerPoint files, which are time stamped by a secure time-stamp server, under certain circumstances, have the validity of a notarization.
Hopefully this answers your question. Please let us know if you have any further queries.
Kind Regards,
Sarah
Microsoft Office Trainer
RE: Digital Signatures - How to confirm they are genuine
Hi,
Thank you for your response.
When I try this at work the person who signs the excel sheet gets a pop up that says "The certificate you selected cannot be verified. Please check your network connection. Do you want to use this certificate? (Y/N)"
Now I did not select any particular certificate so I don't know why I get this pop up.
Also when I try and save the document I am told that:
"Saving a copy of this workbook will remove all of the signatures in the copy. Do you want to continue (Y/N)?"
Which defeats the whole purpose of getting it signed anyway!
If you have any advice I would be grateful.
Best regards,
Andy
RE: Digital Signatures - How to confirm they are genuine
Hi Andrew,
About this below.
"The certificate you selected cannot be verified. Please check your network connection. Do you want to use this certificate? (Y/N)"
I have found a very good explanation if you follow the hyperlink below
https://answers.microsoft.com/en-us/msoffice/forum/all/the-certificate-you-selected-cannot-be-verified/4bb05f5c-9c56-4476-a914-37029321b267
and about:
"Saving a copy of this workbook will remove all of the signatures in the copy. Do you want to continue (Y/N)?"
The Excel file needs to be signed every time you have done changes. Do the changes and save the file and then sign it and close it.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 23 May 2019: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Make a quick copy of a worksheetHold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too. |