problem calling functions in Excel

[dvlassopoulos]

I installed latest version of BERT, but having a little trouble with Excel (2016 32-bit). I opened the example files and any cells containing a call to an R function return #NAME?. The BERT Console window seems to be working - I also tried creating a function following instructions provided with the same result. Any suggestion would be appreciated.

[amaeckelberghe]

Hi dvlassopoulos,

Usually when Excel returns #NAME it is because it was not able to recognise the function you used. Is it possible your function in BERT was not successfully sourced (this could be due to numerous reasons, for example some issues related to packages in case you use these). When a script is successfully loaded you should see a line in your BERT console like:
"Loading script file: C:\Users<Your Name>\ Documents\BERT2\functions<Your File>.R"

[onpikono]

This is most probably the same problem as discussed here: https://github.com/sdllc/Basic-Excel-R-Toolkit/issues/106