RExcel: RServer seems to have been disconnected or closed

[rsadler]

Hiya,

When trying to start R from inside the Excel add-in I'm coming up with the message:
"RServer seems to have been disconnected or closed"
as the first of three.

This is after installing latest version of RandFriends.

The install was a local one.

My machine is 32bit i3212 @ 3.3 Ghz 4GB Ram

Can't seem to locate a similar message on the list.

Regards
rohan sadler

[DeanG]

I have exactly the same problem. Are you using Excel 2010? I am going to revert to a previous version of the R and Friends setup.

[DeanG]

I tried installing previous versions, but none of them have worked.  Did you find a solution?

[DeanG]

So the following solution worked for me:

1. Uninstall your existing R and Friends setup. There are potentially quite a few components you might need to uninstall. I would suggest the correct reverse sequence i.e. RExcel, StatConnDcom, R

2.  I downloaded the versions of StatConnDCOM and RExcel from http://rcom.univie.ac.at/download.html

3. Install R

4. Install StatConnDCOM

5. Install RExcel

6. The following packages were downloaded from CRAN and then installed: rscproxy and rcom

7. Then the COM components need to be registered. At the R prompt enter the following commands:

> library(rcom)

> comRegisterRegistry()

> comRegisterServer()

n.b. I think it might be worth trying step 7 with your existing installation of R, before you uninstall. Let me know if this works for you.

After doing this I was able to start the R Server from the Excel add-in menu in either forground or backgreound mode.

[Branimir Hackenberger]

Suggestion from DeanG is fine. Namely, it seems that there is something wrong with newest RandFriend version. After I reinstalled R, DCOM and RExcell (manually), everything is working perfect.

[mlefcowitz]

I am having the same problem with the 2.15 release.

Tried above instructions.  Following results on registration commands:

> library(rcom)
>
> comRegisterRegistry()
NULL
>
> comRegisterServer()
NULL

Just reinstall 2.13.1 V3 until they work out the bugs?

[rsadler]

Hi All,

I've tried the above solutions, but it seems that my issue is more related to a known and sinister bug - namely that I am using Excel10, and there are issues with accessing the registry at install given I'm behind a firewall. I'll let the thread know if, and when, a solution is found after talking to IT.

Damn, and I was going to do such interesting things ...

Regards
Ro