I am receiving a #NAME? error in several formula fields after compiling my spreadsheet.
I do not have any errors on my original spreadsheet.
I am running Windows 10, Excel 2016, and XLS Padlock 2020.1.
Edited to say: I removed all of the Formula Protection in XLS Padlock and that fixed the problem, but that is not ideal. I want to protect some of my formulas.
I noticed in the manual that using “Hidden” under the Protection Tab can cause problems. That is also not ideal, especially if I can’t protect all of my formulas due to the number and types of formulas I am using. Since some of my formulas are very long and complicated XLS Padlock will not protect them, so I want them hidden. But these formulas are sometimes dependencies for ones that I do want to protect.
How can I work around this?