Monday, May 1, 2017

Excel: Power Pivot/Power Query and Solver

There is an interesting interaction between Power Pivot (and Power Query) and Solver:

image

There are some known issues, but there is reason for optimism:

image

Unfortunately, no cigar, my Office is up-to-date:

image

References
  1. File not found: solver32.dll: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10/fine-not-found-solver-32dll/3c9022c9-ad94-45f7-a218-baafd70355ed