Project locking error - Column doesn't exist

XLS Padlock
1

I’m creating the EXE file from an Excel document (Office 2019 - Microsoft 365, version 16. XLS Padlock version 2020.0). I have several tables (and formulas refers to them) inside the excel document and during the “Building secure application” process, an error occur. This error message is “VBA Project Locking Error - The column " columnName " in formula “tableName[[ columnName ]]” doesn’t exist.”.

This error is not referred to every table, but only to specific ones. But there aren’t errors in the original Excel document and everything works fine. Instead, in the formulas inside the secured EXE file, the referement to these tables are replaced with #REF!. I tried to change the column name and table name but XLS Padlock error persist. If I remove the formula with referement to these tables the error disappear, but obviously this is not a solution.

Sometimes, when this error occur during the EXE creation process, then the EXE file crashes at the startup. But it is random and I don’t know why this happen and how it is related with the error.

I also tried to check the setting “Disable formula and VBA protection (Excel 200 compatibility)” but nothing change.

An image of the error is attached (Mese2 is the table column name and tblSimFinPianiAmmort1 is the table name).
padlock_error

Can anyone help me? Thank you very much.

2

Do not use this option.

Try the following option instead:

image

3

Thanks for the reply, but enabling that option it cause this error during the process of buinding the secure application:
img3
But the formula specified by the error is correct and works fine inside Excel.

When I open the EXE file, this error is showed:
img4

Thank you

4

Could you post the entire formula here (or with PM for privacy)?

5

=SCARTO($D$2;GRANDE(SE(rngMesiList>0;RIGHE(rngMesiList));1)-(12-meseCorrente);0;RIGHE(rngMesiList)-meseCorrente+1;1)

Italic text are defined names, rngMesiList is a range with month names and meseCorrente in the number of current month.

Thanks

6

Could you try XLS Padlock 2020.1? The internal workbook engine was a bit improved since 2020.0.

7

Thank you, how can I upgrade the XLS Padlock version?

8

Check if your maintenance is still active at https://www.xlspadlock.com/account
If yes, just download the new installer from the usual place at https://www.xlspadlock.com/download