First I need to protect my base file “program” with XLS Padlock. Once I open the “program” I will change the input values and save as an output file (also protected now). I then need to take several of these output files and have data pulled over to a summary file (can also be a protected file) with “indirect” formulas. Is this possible with XLS Padlock?
XLS Padlock was designed to work with one protected workbook. It won’t handle relationships between different protected workbooks because they will live in different Excel secure instances at runtime.
If your other workbooks weren’t protected into EXE too with XLS Padlock, maybe this would be possible.
A workaround would be using another unprotected workbook file stored at the same location and shared between the protected workbooks. However, we haven’t tested this scenario yet.