Password Protection - Unable to open Password protected file even though password is correct

Hi,


I am password protecting an Excel file as follows

n

Dim excel As Workbook = New Workbook(Filename)

excel.Settings.Password = "123"

excel.Save(Filename)


The resulting file will not open in Microsoft Excel 2008 for Mac, Version 12.3.2. I get a password prompt, but even with this simple password, Excel does not accept the password, I get an error dialog that states the password is incorrect, and I cannot access the file. Any help appreciated.

Hi,


Does it work fine on Windows environment with MS Excel 2007/2010 (Windows) ?

If you find this issue on both MS Excel (windows) and MS Excel (Mac), kindly give us your template Excel with more details, we will investigate and look into your issue soon.

Thank you.