Save isn't re-sourcing the functions.R file

[ghost]

it looks like a previous version of Bert had a button in Excel that would force a reload of the functions.R file. But the current version is supposed to do that when I click Save. Unfortunately it isn't working that way. I have to close open Excel to get it to access the new functions.

Any ideas what I could be missing?

[duncanwerner]

Not sure, but I have heard similar things before. Are you seeing any error messages in the console, or is it just not doing anything?

I would guess that it's due to either machine configuration or security. We set up the directory for BERT files in your home directory -- is that in a privileged location, or locked down, or on a network drive? I can probably figure it out but it will help if I can reproduce it.

[duncanwerner]

As a workaround, there's an older function which will reload that you can call from the BERT console:

BERT$ReloadStartup()

[mryoHouston]

I allowed the installer to default install BERT (and embedded R) to C:\Users<>\AppData\Roaming\BERT I'm pretty sure that folder is managed by our network IT somehow. It was definitely a hidden folder. I set it to not be read only but its still not saving. I'll try installing to a different folder. The BERT$Reload does work though... so not sure why Save wouldn't if Save is just calling that function. I'm also having trouble with the add-in not loading when I open Excel, there is some kind of hangup and then excel disables the add-in. Excel 2013.

From: duncanwerner [mailto:[email protected]] Sent: Thursday, November 30, 2017 10:25 AM To: sdllc/Basic-Excel-R-Toolkit [email protected] Cc: DiCaro, Mario [email protected]; Author [email protected] Subject: Re: [sdllc/Basic-Excel-R-Toolkit] Save isn't re-sourcing the functions.R file (#89)

As a workaround, there's an older function which will reload that you can call from the BERT console:

BERT$ReloadStartup()

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/sdllc/Basic-Excel-R-Toolkit/issues/89#issuecomment-348240840, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AghzIS3UP23wXVYdfx3-MNY7zeO94ov5ks5s7tbTgaJpZM4QvkfP.

Mario DiCaro

VP, Capital Modeling & Analytics Tokio Marine HCC [email protected] Tel: 713-744-3725

tmhcc.com

A member of the Tokio Marine HCC group of companies. Tokio Marine HCC is the marketing name used to describe the affiliated companies under the common ownership of HCC Insurance Holdings, Inc. Tokio Marine HCC’s products are underwritten by American Contractors Indemnity Company, HCC International Insurance Company PLC, HCC Life Insurance Company, HCC Specialty Insurance Company, Houston Casualty Company, Lloyd’s Syndicate 4141, United States Surety Company and U.S. Specialty Insurance Company.　 For more information about Tokio Marine HCC, please visit www.tmhcc.com.

This email message (including any attachments) contains confidential information and is for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient or have otherwise received this email in error, please contact the sender by reply email and permanently destroy all copies of the original message and any attachments.

[malcook]

re "Save is just calling that function" - it is not - BERT is actively scanning for changes - if you edit the file some other way you should see it get reloaded.