Excel 2007 has a bug related to Excel 2003 and WordArt – Microsoft has a fix if you need the hotfix. Microsoft has released a ‘hotfix’ to a repair a bug that arises in Excel 2007. The problem is described thus: ” Consider the following scenario: You create a new file in Excel 2003 that […]
Excel’s options for shading alternate rows are limited and sometimes ugly. Here’s how to take full control and design the way you like I sometimes wonder whether Microsoft spends so much on its programming budget it has little left over to spend on designers. This thought often crosses my mind when working with Office sample […]
An explanation of the logic behind alternate shading rows or columns in Excel. If you’re content with this result and don’t need to know the nuts and bolts, class dismissed. If, on the other hand, you’d like to understand how we end up with a checkerboard pattern from this expression, stick with me. Unless you […]
Excel can’t add up properly – is that an acceptable compromise or something Microsoft should fix? We’ve been covering the Excel addition issues in a series of recent articles starting here. To round out the coverage we’ll now take a look at the arguments pro and con so that Office Watch readers understand the limitations that […]
Microsoft has a standard response to any maths anomalies in Excel – KB214118 – we have a look at what it says and doesn’t say. Microsoft has a ‘get out of jail free’ card when it comes to floating point / binary math errors in Excel – it’s called Knowledge Base article 214118 and it’s […]
