Microsoft has confirmed the existence of a serious bug in Excel 2007 that can cause an incorrect amount to appear in a cell. The problem that has been isolated so far occurs when a calculation should produce the result of 65535. Instead of the correct result, Excel displays 100000. For example, enter the following formula in an Excel 2007 cell:=77.1*850You will see that 100000 appears as the result. Other formulas have the same effect.It should be noted that, although the spreadsheet displays 100000, the value of the cell is correct at 65535.

In common with many of the features of the Office suite, working with Excel pivot tables has been changed both by the application of the new Office 2007 interface and by several specific enhancements.Creating a pivot tableFirst find the PivotTable option. Although PivotTables used to live in the Data menu, the new ribbon interface has moved the PivotTable option to the Table section of the Insert ribbon.

It's not just teenagers and bored employees who spend time posting on the likes of Facebook and MySpace to chat with their friends – more than a tenth of the sites' users visit them for business reasons, it has been claimed.Research group emedia found 11% of respondents use social networking websites for business purposes with another 8% contact existing or potential clients via the services.Facebook in particular has come in for strong criticism

The generation that refuses to age is not going to sit back and wait for Alzheimer's Disease and other signs of dementia to take hold. Instead, savvy Baby Boomers are expanding their minds (no, not the way they did in the 60s) with the aid of the computer, puzzles, and games.

At the end of August, an Iowa district court approved a $180 million settlement against Microsoft in an anti-trust class action suit. The Iowa claim alleged the company had used its monopoly position to overcharge consumers for its Windows and Office programs. Under the settlement, Iowa residents who bought Microsoft software between May 1994 and June 2006 will be entitled to refunds in the form of cash or vouchers they can spend on new Microsoft products or PCs.Word users will get $10 back per license, while each Excel user will be entitled to $25.

Despite understanding how valuable blogging can be, many firms are still failing to fully embrace it. Marketing management provider WebTrends found that contrary to 85 percent of marketers' perceptions that an effective web presence is important in achieving sales and objectives, just 5 percent blog on a regular basis.Instead, its research showed Internet tools such as e-direct and web analytics continue to dominate. Podcasts are another medium to watch for business, says the firm, as despite relatively low usage at the moment, it registered the highest level of user satisfaction.