Excel Solver disabled by Matlab

I am using Matlab to open an Excel worksheet in which Excel Solver has been added. However when Matlab opens the worksheet the Solver tab does not appear in the worksheet, even though it is enabled in the Excel setup. If I open the same worksheet manually Solver appears as it should. What can I do to keep Matlab from disabling Solver?

Answer 1

[Ayush]

Hi @Michael Burnett

You can try use MATLAB to explicitly load the Solver add-in when you open Excel. Here is the sample code for this:

% Start Excel application
excelApp = actxserver('Excel.Application');
excelApp.Visible = true;

% Open the workbook

filePath = fullfile(pwd, 'fileName.xlsx');
workbook = excelApp.Workbooks.Open(filePath);

% Access the Add-ins collection
addIns = excelApp.AddIns;

%Find and load the Solver add-in
for i = 1:addIns.Count
    if strcmp(addIns.Item(i).Name, 'Solver Add-In')
        if ~addIns.Item(i).Installed
            addIns.Item(i).Installed = true;
        end
        break;
    end
end

I hope this helps!