Link to home
Start Free TrialLog in
Avatar of sccmha
sccmha

asked on

how do i modify a locked excel spreadsheet

how do I modify a locked excel spreadsheet?
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

You have to unlock it first.

Tools>Protection>Unprotect sheet or Unprotect workbook, depending on what has been protected and what you want to do.(XL2003 and earlier, for xl2010 it's the Review tab))


If a password has been applied then you need to supply the password to unlock it.
ASKER CERTIFIED SOLUTION
Avatar of Wiesje
Wiesje
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial