I received this message today while trying to test the foreground connection within ScExcel; "Error creating R connection object, error code 2147745840: Debug info: If you are using the foreground server, please make sure R is running and rcom is loaded."
I ran the test and everything checked out "OK". I am using a commercial version, not a home & student and this is the first time I've encountered this message and have been using ScExcel since early 2018 with no similar issues.
