Ask Your Question
0

Can't Edit Excel Worksheet

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

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

Comments

Hello - perhaps opened "write-protected" ?

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

Also: The single sheet might be set protected.

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

how to remove the protection?

jackgag gravatar imagejackgag ( 2019-03-29 03:08:52 +0200 )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 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2019-04-01 18:04:57 +0200

hey, maybe your sheet needs acess to edit. you should try to get acess from the sender.

edit flag offensive delete link more
0

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

Kaser gravatar image

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

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: https://www.androidphonesoft.com/resources/unprotect-excel-sheet-without-password.html

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 100 times

Last updated: Apr 01