This issue is introduced within the Windows Operating System itself, most often seen in Windows 10. There should be no need to uninstall and reinstall the Analytic Solver or Microsoft Office. When the issue is present, you may see dialog boxes that look like this:
Or you may be missing some Parameters for specific operations, such as Simulation Parameter Analysis:
Lastly, if you create a Chart using the Data Mining Chart Wizard you may not be able to interact with it and must force close Excel to get it to go away.
Such issues are "tied together" and are generally resolved with the same set of steps.
Please try these two options:
- Completely update your Windows OS through Windows update if possible. If not possible, skip to 2 below.
- https://support.microsoft.com/en-us/help/4027667/windows-10-update
- Note: You will want to ensure your Windows Operating System build is at least build 1803 to ensure full compatibility. More information on how to check this can be found here.
- Note: You will want to ensure your Windows Operating System build is at least build 1803 to ensure full compatibility. More information on how to check this can be found here.
- https://support.microsoft.com/en-us/help/4027667/windows-10-update
- Change your Excel "When using multiple displays" setting to "Optimize for compatibility". This will take affect even if only one Monitor/Display is active.
- Open an Excel file (new or pre-created)
- Click File at the top left of Excel
- Select Options
- Ensure you are at the "General" tab on the left
- Locate the "User Interface options" - at the top by default, you may have to scroll up to find it
- Select the radio button for "Optimize for compatibility"
- Click OK
- Close and Reopen Excel and test the problematic operation(s)
If you have a question about the above information please let us know via email to support@solver.com.
Comments
0 comments
Please sign in to leave a comment.