Unlock Excel Workbook

Hi, I have an excel file that we are wanting to pull data from. The problem is it is locked and cannot open it without the password and the person is gone that locked it. How do I unlock a workbook if I cant open it at all?

If I sent someone the file can you open it?