We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Can not open a password protected xlsx file

asked 2020-04-12 23:35:44 +0200

C. Martins gravatar image

updated 2020-09-01 12:54:32 +0200

Alex Kemp gravatar image

I have an xlsx file that has been created with Microsoft Office Word and password protected. After that, I started open and edit it with LO 6.0.1. When I opened it in LO it asked me for the password only for the first time. After that, it never asked me again when I open the file.

Today I have used the operation "Save As" and indicated to protect the file with a password. However, after that whenever I try to open the file and give the password the LO Calc always says that the password is wrong and I can not open it. But the password is correct.

I have already updated my LibreOffice to version but the problem remains.

Any help with this problem? Since unfortunately, I do not have any copy of that file :(

Thanks in advance for your help.

C. Martins

edit retag flag offensive close merge delete


some basic troubleshooting options are:

  • try blank password
  • try entering exact filename (including correct capitalisation/casing) as password
  • check to see if your system language,region,keyboard codepage has changed.
  • run LibreOffice under a different machine, eg try using Virtualbox.
  • try a different software to open. even a cloud based software may work
blashrkh gravatar imageblashrkh ( 2020-04-13 04:37:23 +0200 )edit

Please check if related: https://ask.libreoffice.org/en/question/226282/password-incorrect-with-xlsx-file/ (for long password longer than 15 characters).

Mike Kaganski gravatar imageMike Kaganski ( 2020-04-13 06:43:32 +0200 )edit

Dear Mike Kaganski,

Thanks a lot for your precious help. In fact, your solution was the right one since my password has 23 characters. I simply inputted the first 15 has suggested and magically it opened immediately. I have already tried it in LO 6.4 with a password bigger than 15 characters and the problem have already been corrected has said.

Thanks a lot. You can imagine but you saved my day. Thanks for all the other people that gave me other tips too.

C. Martins

C. Martins gravatar imageC. Martins ( 2020-04-13 11:08:30 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-04-13 01:08:24 +0200

keme gravatar image

updated 2020-04-13 01:09:38 +0200

The only possible solution I can see is if the Caps Lock was set when you entered your password. If you have a small keyboard without separate numeric keypad (typically a laptop computer), Num Lock may also have come into play.

Try the password with different initial settings for Caps Lock and Num Lock. (There are 4 different combinations.)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-04-12 23:35:44 +0200

Seen: 822 times

Last updated: Apr 13 '20