This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English version of the page.

Note: This page has been translated by MathWorks. Click here to see
To view all translated materials including this page, select Country from the country navigator on the bottom of this page.


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


Setting 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.