Locked Cells cannot be modified
I searched and found a thread on this topic. It is not answering my question.
Problem with data table cells being locked
I click on any cell in the Run Time QTP 11 workbook. It gives an error Locked Cells cannot be modified. I thought is was an QTP issue until I exported the workbook.
In Excel it behaves the same way.
I cannot find anything in Excel having to do with locked cells. Actually the entire sheet is not editable in Excel. Any ideas anyone?
I found a fix.
export the workbook. Right click on the workbook in QTP and use Export.
Open it in Excel.
Tools from the menu bar.
Unprotect the book.
Then I imported the workbook back into QTP.
Now I can edit it again.