Connecting Excel® to a COMSOL Server
The default settings using LiveLink™ for Excel® consist of starting a COMSOL Multiphysics server locally on the computer the first time a model is loaded from the spreadsheet. You can also specify an already running COMSOL server to connect to from within Excel by following the steps below:
1
Start Excel and separately start a COMSOL server.
2
In Excel, go to File ribbon tab and select COMSOL.
3
In the COMSOL Backstage go to Server and click Connect ().The Connect to Server window appears.
4
In the Server text field enter the COMSOL server name (or server IP address). Enter localhost if the COMSOL server and Excel are running on the same machine.
5
In the Port menu list select manual if the COMSOL server is not listening to the default port number (2036). The port number is the one displayed in the COMSOL server window.
6
In the User and Password text field enter the login information requested by the COMSOL server.
7
Click OK.
When connecting from within Excel to a COMSOL Multiphysics server not using graphics, you need to connect the server to a COMSOL Desktop to display graphics for the current model. See Connecting the COMSOL Desktop® to a COMSOL Multiphysics Server.