Main Content


Change preferences

Spreadsheet Link™ has preferences that control Spreadsheet Link and MATLAB® functionality. For example, you can use different preferences to control how Spreadsheet Link and MATLAB behave with startup, data, and error handling.


MLAutoStartAutomatically start MATLAB
MLProgramIdSpecify MATLAB version
MLStartDirSpecify MATLAB current working folder after startup
MLUseFullDesktopSpecify whether to use full MATLAB desktop or Command Window
MLMissingDataAsNaNSet empty cells to NaN or 0
MLUseCellArrayToggle MLPutMatrix to use MATLAB cell arrays
MLShowMatlabErrorsReturn standard Spreadsheet Link errors or full MATLAB errors


Set Spreadsheet Link Preferences

Set preference settings for Spreadsheet Link and MATLAB to control how the software behaves when Spreadsheet Link starts MATLAB in Microsoft® Excel®.

Localization Information

Consult Windows® regional settings for non-English environments.