Hi Stuart, I am not able to adjust the spending strategy controls under the Run Analysis tab. The Monte Carlo Analysis runs fine but I am not able to change the Spending Strategy. I'm on MacOS Big Sur 11.2 on a iMac (Retina 5K, 27-inch, Late 2014) with a 3.5 MHz i5 4-core processor and 32GB RAM. 2016 Excel for Mac is version 16.16.27.
Thanks,
Frank
Frank,
We did encounter this issue (form control combo boxes not working) during beta testing of PRC2021 and it was resolved via an update to Excel. The Mac configuration was very similar to yours but involved Excel version 16.16.17 on this particular tester's Mac. He upgraded to Excel 2019 version 16.44 and the problem disappeared. I'm running MacOS Big Sur 11.1 on my MacBook Pro with Excel 2019 v 16.44 and it runs well and without the issue you've described.