After checking the spreadsheet and verifying all the details, with the digital signature we can confirm if we are the authorized person for the same. You would see one or mostly likely can figure it out yourself.MS-Excel 2013 allows you to add the digital signature to the workbook files. (I am not allowed to post the link here so just google for "Add multiple signatures to excel document"). Once completed, follow the instructions on a video that I found on YouTube on how to Sign in the appropriate box. for the next Signer in line.Īdd as many signature boxes as you need just by Copy and Paste, then update the Name and Title etc.
Then you can right click on the 2nd signature box and select Signature Set Up.
Right click on the box, and click on Copy. COPY and PASTE.įirst, add the first signature box like you would normally do. It worked!!!! It turns out to be pretty simple. So I got an idea and tested this trick out myself. The video only shows you how to sign but does not show you how to set up multiple signature. I was searching for an answer as well and was pretty frustrated until I saw this YouTube video. The whole point is that the spreadsheet keeps being edited with more and more data added as the tasks are being completed and I just need a form of signature of who completed which task when, while being able to keep editing the spreadsheet in the meantime.Ĭan anybody recommend an alternative solution of a way to make the Microsoft digital signatures work for that use case? I have done quite a bit of searching and it looks like even though many people have reported the same issue, there is no solution offered. If I choose "Edit Anyway", the first signature disappears, even if I choose the level of commitment to "none", which kind of defeats the purpose of having multiple signatures. I have tried using the digital signature feature provided by Microsoft as detailed in, the only problem is that it appears to be designed to be used only once per document.Įven though I am able to add multiple signature lines to the same spreadsheet, once one is signed, I get the following message: I would like each person to sign off each task on the spreadsheet after it's done so that we have a record of who did what and when. On that spreadsheet, I have a worksheet with a list of tasks that have to be completed, but not necessarily by the same person and certainly not at the same time (it takes about 2 weeks to complete all the tasks on that list). I have an Excel spreadsheet that lives on a shared folder, that everybody can access.
0 kommentar(er)
