XLSLIM_RUN_AT_START not recognized

[Matthew Berry]

My excel sheet has an XLSLIM_RUN_AT_START named range, which contains a call to RegisterPyModule().  The cells in this range do NOT get executed on load, so my custom functions show NAME errors until I manually recalc that cell.

Here is the log file showing that xlSlim does not find the "run at start" range. However, when I manually recalc the cell in the range, it does find it.

Can you help me resolve this issue?  

Log:

2023-08-04 10:22:02.6575 DEBUG xlSlim.AddInRegistration Named range XLSLIM_RUN_AT_START not found
2023-08-04 10:22:18.0067 INFO xlSlim.AddInRegistration Calculated cell "$B$8" in named range XLSLIM_RUN_AT_START

[xlSlim Dev]

Hi,

I will investigate. To make sure I understand correctly - you had to manually recalc the cell B8 and then the “run at start” range was found when the sheet was reopened?

Thanks,

Russel 

--
You received this message because you are subscribed to the Google Groups "xlSlim Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xlslim-suppor...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/xlslim-support/6f3d53e7-4947-4091-a3da-a6a0b129318bn%40googlegroups.com.

[Matthew Berry]

I have to manually recalc B8 every time the sheet is opened. xlSlim never recognizes the XLSLIM_RUN_AT_START range, in which B8 resides.

[xlSlim Dev]

Hi,

I have found the issue. The cells are being recalculated, however the Python registration functions are not compatible with running within an Excel WorkbookOpen event. I'll address this in the next release which should be mid-August.

Regards,

Russel

[Matthew Berry]

Great! Thank you!

[xlSlim Dev]

Hi Matt,

v3.1.1 is released and available from https://delivery.shopifyapps.com/-/5c24fb74f0fb9919/74836f4cad30a268

Please let me know if that works for you.

All the best,

Russel

[Matthew Berry]

Thanks Russel!