Software

Ask something
Discussion Locked

Excel cell protection

0 helpful
3 replies

by dewi.lloyd

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an excel spreadsheet that was first created back in 2001 by a third party. We have recently moved from Office 97 to Office 2003 and I now find that a number of cells in the spreadsheet are suddenly protected when I open it in Excel 2003. If I open the sheet with 97 it functions fine. If I try and unprotect the sheet I get asked for a password, which I don't have. Has anybody come across anything like this and have any thoughts ?

3 replies

by chitosunday

Is there a macro in the sheet? If there is , try opening it in excel 97 with macro enabled. Then in excel 2003 open it with macro disabled.

by dewi.lloyd

There are indeed some macros. I have tried opening the sheet with them disabled and have the same problem.

This discussion is closed to new replies.