Basic-Excel-R-Toolkit icon indicating copy to clipboard operation
Basic-Excel-R-Toolkit copied to clipboard
verified publisher icon sdllc

problem calling functions in Excel

Open dvlassopoulos opened this issue 7 years ago • 2 comments

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.

dvlassopoulos avatar May 26 '18 17:05 dvlassopoulos

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"

amaeckelberghe avatar May 29 '18 12:05 amaeckelberghe

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

onpikono avatar Jun 09 '18 22:06 onpikono