General discussion


Excel cell protection

By dewi.lloyd ·
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 ?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by chitosunday In reply to Excel cell protection

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.

Collapse -

by dewi.lloyd In reply to

Poster rated this answer.

Collapse -

by dewi.lloyd In reply to Excel cell protection

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

Related Discussions

Related Forums