Excel Solver running issue

Sai Krishna 1 Reputation point

Hi recently I have created a document with embedded formulas, which internally use vba script and uses solver operation of Excel. Observed a peculiar behavior that, solver pop up appears while running, and pauses the operation if Excel window is not active, (i.e if we start the solver operation and if we shift to another application, solver seems to pause until the excel window is activated back.) Can this scenario be avoided?
Even if we shift to some other application, the excel solver operation should continue its work parallelly. Is this scenario observed earlier. The overall execution time also varies due to this behavior.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,202 questions
Microsoft 365 Publishing
Microsoft 365 Publishing
Microsoft 365: Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line. Publishing: The process of preparing, producing, and releasing content for distribution or sale.
513 questions
No comments
{count} votes