A worksheet function does not work

[Q] When I call an XLPack worksheet function, it does not work.

[A] If an XLPack worksheet function does not work, it may be a good idea to check whether it is a VBA function call.

XLPack function names start ing with W are worksheet functions, and others are VBA functions. Therefore, functions which names do not start with W cannot be called from within worksheets.

You usually cannot call VBA functions as worksheet functions in the worksheet (#NAME? error occurs). However, you can call them in the Excel worksheets that references XLPack.xlam and in all Excel worksheets if "XLPack VBA Library" is enabled as add-in. In those cases, the called VBA function returns a meaningless value or an error in most cases, but it sometimes works and it sometimes crashes.

Note - "XLPack VBA Library" addin is not necessary if you use only the worksheet functions and do not use the VBA functions. In such case, it is recommended to disable "XLPack VBA Library" addin.

You can also distinguish the worksheet functions by checking the category. When you click fx (Insert Function) of formula bar, XLPack worksheet functions will be displayed under category "XLPack".

Normal VBA functions will be displayed under category "User Defined" and no help is available. Do not use these functions in worksheet.