Ask Your Question

Can't Edit Excel Worksheet

asked 2019-03-27 03:31:23 +0100

jackgag gravatar image

It is an excel file with .xlsx extension. I can open the workbook but can't edit the text in one worksheet.

edit retag flag offensive close merge delete


Hello - perhaps opened "write-protected" ?

Opaque gravatar imageOpaque ( 2019-03-27 10:04:08 +0100 )edit

Also: The single sheet might be set protected.

Lupp gravatar imageLupp ( 2019-03-27 15:54:59 +0100 )edit

how to remove the protection?

jackgag gravatar imagejackgag ( 2019-03-29 03:08:52 +0100 )edit

The dropdown menu of the sheet should contain an item Protect Sheet…..
-1- If the sheet isn't protected, you get a dialog offering to protect it. Your problem must have its origin elsewhere in this case.
-2- If the sheet is protected with the empty password, the protection will simply be removed.
-3- If it is protected with an actual password, you need to enter the PW. Since you obviously don't know it, you need to get more detailed help about removing sheet protection by file manipulation. I personally never did it for any Excel file. Anyway I would save a copy of the document in LibO native format first.

Lupp gravatar imageLupp ( 2019-03-29 09:21:42 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-03-29 07:29:09 +0100

Kaser gravatar image

updated 2019-04-01 08:34:46 +0100

It seems like this worksheet is password protected, so you can't edit it, right? if so that,the password? When you were trying to edit it, it didn't ask you for a password? Cracking it with this program:

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-27 03:31:23 +0100

Seen: 1,664 times

Last updated: Apr 01 '19