Why do I receive a syntax error or encounter problems when using MLGETMATRIX in Excel Link 2.0 (R13) when the sheet name contains special characters?

I have an Excel spreadsheet where some sheet names contain spaces, commas, hyphens, or other special characters. When I enter the MLGETMATRIX command and specify these sheets, I receive a syntax error in Excel. The string "#SYNTAX?" is displayed in the Excel spreadsheet. In addition, MLGETMATRIX may cease to work until I close and re-open Excel.

Answer 1

[MathWorks Support Team]

This enhancement has been incorporated in Release 2006a (R2006a). For previous product releases, read below for any possible workarounds:

There is an omission in the documentation for Excel Link 2.0 (R13). The documentation should include the following information:

To access sheet names that include special characters, you must enclose the name in single quotes.