I was wondering if I could manually update the sign-off column somehow? For example, I sent a document for approval, approver viewed document in excel online, didnt close it and approved the document. I recieved the following email below.
User signed off on your item. Note that we were not able to update the column in SharePoint because the file was locked by a user.
When the approver closed the file, the sign off column didn't update and stayed on Pending. Only way to change that status to approved is to resend the the approval and the the approver needs to make sure to close the document before approving.