Forgot Excel Password

Here are some links that will help you better understand the password settings in Excel.

Changing a password on a password protected Excel

How do I unlock a Workbook, Worksheet, VBA Project, without a password?

Video: Protect an Excel file

Video: Restrict changes to files

Protection and security in Excel

You may try to search here what is in title of your post, lot of threads are here

Some of them are on many pages as I remember.  Perhaps these two could be useful

https://techcommunity.microsoft.com/discussions/excelgeneral/remove-password-from-excel-spreadsheet/2936709

https://techcommunity.microsoft.com/discussions/excelgeneral/excel-sheet-forgotten-password/3545763

If you are able to download the Excel file, you can remove the password.

1. Download a copy of the Excel file.
2. Rename your .xlsx (or .xlsm) file to .zip.
3. Extract/unzip it.
4. Go to the xl/worksheets/ folder.
5. Open the relevant sheetN.xml file in a text editor (Notepad++, VS Code, etc.).
6. Search for sheetProtection.
7. Delete the whole tag (it looks something like <sheetProtection algorithmName="..." password="..." ... /> or with hashValue/saltValue).

   • If the password protects the workbook structure (not an individual sheet), then the file is xl/workbook.xml and you delete the entire tag using the exact same process.

8. Save the file.
9. Zip the entire folder, not the contents.
10. Rename the .zip back to .xlsx.
11. Open in Excel and enjoy.

Seems there is no way to recover, you may consider some 3rd party tools for help

https://learn.microsoft.com/en-us/answers/questions/5569332/how-can-i-unprotect-excel-sheet-as-i-forgot-the-pa