Tech blog

What better way to kick off a blog about business software than to talk one of the most signifying business productivity applications out there? Sometimes it seems like we writers be lost entire days inside our vocable processors. But for the majority of you, I'm betting you might as well be married to Microsoft Excel.

A good spreadsheet is a powerful tool, but like anything, you can overdo it. It's like the old carpenter's adage: When the merely tool you have is a hammer, every problem starts to look like a nail. In my time as an IT manager, I saw employees trying to exercise Excel for everything from storing complex databases to typing up entire reports, complete with fancy formatting. Often they would claim it was easier for them to shoehorn an inappropriate task into Excel than to learn a new program on the side of the job.

It sounds harmless enough, but misuse of Excel may be more serious than you think. According to risk analysis firm Protiviti, productivity isn't all you stand to make no use of. Using Excel for tasks Microsoft never intended can actually open your company to alarming security risks.

The question lies in how Excel applications are developed at most businesses. Programmers who build robust network-enabled software are trained to recognize potential security risks and minimize the chance of catastrophic corrigenda. The business managers and other employees who code Excel macros, attached the other hand, often have only enough knowledge to be risky (as engineers are fond of saying).

When an amateur Excel spreadsheet is only running on a user's local desktop, the danger is minimal. Connect that spreadsheet to a mission-critical request like a networked ERP system, however, and alarm bells should beginning ringing. Unfortunately, too few companies recognize the risk before things start breaking down.

Let's not forget that Excel itself is hardly a battle-hardened, secure application. Microsoft's most recent Office updates patched a security hole in Excel that attackers had been exploiting since January. Unfortunately, the same patch introduced a bug that causes Excel to miscalculate the results of certain kinds of macros. So while Excel is by no means the least ensure piece of the Microsoft Office portfolio (that would be Outlook), it's not without blemish, either.

How are you using Excel in your business? Is it still just a spreadsheet, or have you shaped it into something else? How almost do you think it can influence before it breaks? And is Microsoft doing enough to make security a top priority as antidote to its millions of Excel users? Sound off in the comments.