Business IT - Technology for your business

No. 1 Story

Telstra adds one million mobile services, but Sensis plummets

Telstra has revealed the addition of almost one million new mobile services in the six months to December 2011, but Sensis revenues plummeted 24 percent in 12 months.

read more

Solver to Mac Excel users: 'I will return'

Business IT - Technology

Like General Patton's famous promise to the Philippines during World War 2, Microsoft's MacBU is telling Excel wielding Mac users that the Solver add-in will be making a comeback.

Solver implements within Excel a technique called linear programming. This involves finding the minimum or maximum value of an equation, subject to various constraints. This can be applied to a range of business problems. For example, it can come up with a least-cost recipe for dog food, given the prices of various ingredients and the restrictions on the amount of carbohydrate, protein and so on in the blend.

Solver came with Excel 2004 but was dropped from the latest version because Office 2008 does not include Visual Basic for Applications (VBA).

That decision was not popular among many users - even those who never need Solver - because it meant they could no longer use macros created in Word and Excel documents originating in earlier versions including those for Windows.

Microsoft's current recommendation is that people who need Solver should run Excel 2004 and 2008, switching to the former whenever Solver is required. Not very elegant, but there you go.

There is hope: largely due to pressure from the education market, Microsoft is working on restoring Solver to Excel 2008. Yes, the company is talking about delivering the new Solver in an update to the present suite, not as a feature of the next version of Office.

No timeframe has been announced, but it is said to be a top priority for the Excel team, which is exploring two possible approaches.

Loading comments ...

- sponsored feature -

The Death of Traditional BI: What’s Next?

How to Make Business Discovery Work for Your Business IP PABX BUYING GUIDE

Business Discovery takes its cues from consumer apps. Like Google, it encourages us- ers to hunt for and explore data without worrying about or even noticing the underly- ing technology. Their entire experience is working within an intuitive interface to get real-time, self-service results with only minimal training. ...more