MATLAB: Do I receive an error after installing a new Microsoft Office version and using Excel Link with it

errorexcellinkmacroofficeSpreadsheet Link

I upgraded Microsoft Office and tried to use Excel Link as I always did. However, now I receive the following error message:

 Reference to indicated file cannot be added

Best Answer

The default security settings for Microsoft Office do not allow you to run any macros. Therefore, you have to change this setting to be able to work with Excel Link.

You can do this by opening Excel and choosing "medium" instead of "high" from the "Tools -> Macro -> Security" menu.

Related Solutions

MATLAB: Does Microsoft Excel generate the message “Microsoft Excel is waiting for another application to complete an OLE action.” when I use Spreadsheet Link EX

This is the expected behavior for lengthy MATLAB operations, which can exceed Excel's timeout for COM Automation calls.

If you do not expect your operation to take more than a few minutes, it may be waiting for user input (for example, a string for INPUT or a key press for MORE). Check that your code executes without interaction in MATLAB.

If your MATLAB code takes longer than a few minutes, you can disable the Excel warning using the steps below:

1. To disable this warning for one MLEvalString call, edit your VBA code such that alerts are not displayed around the long MATLAB operation:

...
      Application.DisplayAlerts = False
      MLEvalString ("myLongOperation")
      Application.DisplayAlerts = True
...

where myLongOperation is your MATLAB function.

You will need to configure Excel to use MATLAB functions within macros by adding a reference in the VBA environment, as described in 'Work with the Microsoft Visual Basic Editor' in the following documentation:

https://www.mathworks.com/help/exlink/add-in-setup-1.html

2. Alternatively, if using an older version of Excel prior to Excel 2000 that does not reset DisplayAlerts at the end of each macro, you can run this macro once to turn off all alerts:

Sub nomorewait() 
    Application.DisplayAlerts = False 
End Sub

Please note: This approach significantly changes the behavior of Excel --- for example, Excel will no longer ask you to confirm actions that will cause you to lose data.

In some cases, the issue can be resolved by enabling macros in Excel as below:

Navigate to File->Options->Trust Center->Trust Center Settings

Select 'Macro Settings' from left panel and 'Enable all macros' radio button from the right panel to enable macros.

MATLAB: Does the installation of the Excel Link / Spreadsheet Link EX Addin not create a MATLAB toolbar/group

1. Make sure you are using a supported combination of MATLAB release and MS Office release, referring to the getting started section in the documentation:

docsearch('excel link getting started')

2. Follow the steps of installation instructions in the getting started section of the documentation.

3. Make sure you are using the right Addin file (according to your MS Office version).

4. Before you install the Addin make sure the security settings in Excel are not disabling Macros and Addins.

5. If MATLAB does not open immediately after installing the Addin, check if MATLAB is registered as an Automation Server. You can verify this by saving the the following VBS code:

Set MatlabObject = CreateObject("Matlab.Application")
MatlabObject.Visible = 1
MsgBox "Done"

to a .vbs script and run the script (double click). If MATLAB is registered as a COM Server a message box will pop up. Otherwise run the command 'regmatlabserver' in MATLAB, and install the Addin again.

6. If the installation still does not succeed, reset the Microsoft Office User Profile and try again.

Best Answer

Related Solutions

MATLAB: Does Microsoft Excel generate the message “Microsoft Excel is waiting for another application to complete an OLE action.” when I use Spreadsheet Link EX

MATLAB: Does the installation of the Excel Link / Spreadsheet Link EX Addin not create a MATLAB toolbar/group

Related Question