The Mac Observer

Skip navigational links

You're viewing an article in TMO's historic archive vault. Here, we've preserved the comments and how the site looked along with the article. Use this link to view the article on our current site:
Microsoft Announces the Return of Solver for Excel 2008

Microsoft Announces the Return of Solver for Excel 2008

by , 2:05 PM EDT, June 27th, 2008

The linear programming Solver function in Excel 2004 had to be dropped in Office 2008 for Mac because it depended on Visual Basic for Applications (VBA). On Thursday, Microsoft announced that the MacBu is actively working to bring it back in a future update and that it is a top priority.

Microsoft explained in the MacBU team blog "First, Solver ... enables you to do linear programming in Excel, which makes it enormously useful for cracking business problems around scheduling ... capacity planning ... or finding the minimum or maximum value for a problem, given certain constraints."

Now that's it's turned up missing in Excel 2008, the two questions they have received are "What happened to Solver?" and "What should I do to get Solver functionality?" The MacBU answered as follows:

"Solver was not included in Excel 2008 because it depends on Visual Basic for Applications (VBA) to function. When we removed VBA from Office 2008, it meant that we also removed Solver.

Now, on to the second question: 'what should I do to get Solver functionality?' Today, the best option for people who need Solver is to run Excel 2004 and Excel 2008 side-by-side, and switch to the 2004 environment for workbooks that require Solver.

However, we have been hearing loud and clear from our customers, particularly in education, that the side-by-side solution is suboptimal. For many people, Solver is a critical and necessary tool for coursework, and they want to work with Solver natively in the Excel 2008 environment.

We definitely hear you, and we're working on it.

The Excel team is actively working to bring Solver to Excel 2008 as part of a future update. We have two distinct technical approaches and are exploring both. Once we have established which is the best option and have code that meets our quality bar we will announce a timeframe for availability here on Mojo. [TMO emphasis added.]

In the meantime, please know that this is a top priority for the Excel team."

TMO will continue to monitor the progress of this project.

Recent TMO Headlines - Updated December 17th

Sat, 4:45 PM
Get Free Bitcoins from 43 Faucets That Pay
Fri, 5:25 PM
New iMac Pro Launches a New Wave of Macs
Fri, 3:42 PM
Apple Just Signed Third TV Show, This One's a SciFi Space Drama by BSG Creator Ronald D. Moore
Fri, 3:36 PM
macOS: This Tool Can Help You Speed Up Mac Login Times
Fri, 1:48 PM
Rent or Own Movies and TV Shows With Redbox On Demand
Fri, 1:41 PM
Watch the Apple Music Trailer for 'Who Built the Moon Live: Noel Gallagher'
Fri, 1:10 PM
FCC Kills Net Neutrality, Samsung's HomePod Competitor - TMO Daily Observations 2017-12-15
Fri, 12:55 PM
Watch the Apple Music Trailer for 'The Thrill of It All Live: Sam Smith'
Fri, 11:58 AM
Comprehensive macOS Development: $15
Fri, 11:53 AM
Shhh...Apple is Patenting a Way for Siri to Whisper
Fri, 11:06 AM
Samsung Ready to Jump into the Smart Speaker Market with HomePod Competitor
Fri, 9:58 AM
Here's What Would Happen if You Really Used a Lightsaber
  • __________
  • Buy Stuff, Support TMO!
  • Podcast: Mac Geek Gab
  • Podcast: Apple Weekly Report
  • TMO on Twitter!