error message: "the rpc server is unavailable" - what causes it / how to get rid of it?

Hi, I'm getting the error "the RPC server is unavailable" when my MatLab code tries to run a macro within an Excel file, i.e. with the command:

 ExcelApp.Run('makeChart')

The code uses com connections to an Excel file in order to write data and run several chart making macros.

I'm a bit confused because the code runs fine on several other PC's and a Google search for the error doesn't seem to turn up anything useful...

Any thoughts on what could be causing this error would be much appreciated.

Answer 1

[Iain]

I've seen that error when the excel application matlab was interfacing with has closed but it hasn't been replicated in matlab's activex interface object.

[Aiden Coutin]

I had this issue today. I fixed it by opening the Excel file outside of Matlab, making a change and saving it, then trying again.