Not being funny here, but have you contacted the ex-employee and asked them?

I'm not aware of any way around the password sadly.

"Trish35" wrote:

We have had an employee leave and have gone to use work spreadsheets which
this employee applied passwords to. Now we can't make corrections. If we
can not get in we will have to re-do all the spreadsheets