I got it while in Excel before compiling. I was trying to use the formula protection (right-click on the cell and choose formula protection).
I am using V2018.2.
I did have the sheet protected with a password through Excel and when I unprotected it, it worked. On some of the sheets I had to unprotect and some I did not.
I did get it to work every time when unprotected though.
That’s the reason. In order to analyze formulas that will be protected, XLS Padlock must access formulas in cells. If you protect them yourself, then Excel won’t let XLS Padlock read formulas and it will fail. You can also let XLS Padlock unprotect and reprotect cells by specifying a password in XLS Padlock.