Hello,
I’m running into some issues using the formula protection function with XLS Padlock. The formulas use IF and VLOOKUP functions, so the functions themselves shouldn’t be the problem. I noticed that your guide says the formula protection tool is incompatible with the INDIRECT function…my sheet has formulas that use INDIRECT, but the INDIRECT function is not in the cells I am trying to protect. Can INDIRECT not be used at all on the sheet? Is there any other problems you could foresee based on the information I’ve given you?
Please let me know if you need any additional context, and thank you for your help.
Regards,
Evan