Excel 2008 Solver integrated to Excel VBA works very slowly

Asked By Silas Bell 0 points N/A Posted on - 11/14/2011

Hello everybody!

Need your solutions for this. In excel 2008 ‘Solver’ integrated to Excel (VBA) was a different application and it was working very slowly.  If its reverted back, its working good. I hope someone will help me.

• Status: Open
• Question Views: 1321
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by AngeloM

Go To Solution

Best Answer

Best Answer

Answered By AngeloM 0 points N/A #110287

Excel 2008 Solver integrated to Excel VBA works very slowly

You should be able to move Excel workbooks containing Solver models and VBA macros that control Solver freely between Mac and Windows versions of Excel. All versions of Solver from Excel 3.0 in 1990 to Excel 2010 will be available as free

 In Excel 2011 solver is back and it uses VBA for its user interface and Apple’s new Scripting Bridge technology to help with performance. Information Data says that interface matches that of the new Solver in Excel 2010 for Windows.

About AngeloM

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 11/18/2011
• Question Category: MS Excel

Answered By nevkamins 0 points N/A #110289

Excel 2008 Solver integrated to Excel VBA works very slowly

Did you mention that the implementation of macros took a very long time, in this case  I would have been able to recommend  you to bring  alteration   to your code (such as turning off Screen Updating, setting the calculations to manual, using arrays instead of collections, etc.); but the problem with opening, saving and closing a file basically depends on  the SIZE of the file you are using.

One question came to mind is — When is the file connected to the database? If it is connected at the time of opening, then that might be happening due to delay (it could be changed to connecting only when certain processes are running).

The things on which mostly    the size of Excel file depends (with the associated opening, closing, and out-of-memory problems) are stored complex formulas along with a lot of cells. The solution of this problem is the existence of macros which create formulas so that the formulas can be turned into values after the result is computed (by the formula).

To draw a conclusion of this problem —— you have to try with different approaches and you can find out which works best. Do you think that you need 40 worksheets in 1 workbook?

For more info recommends http://vba-programmer.com/

About nevkamins

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 12/13/2011
• Question Category: MS Excel