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
Excel 2007 had a serious bug where some numbers display as ” 100,000 ” regardless of the true value around 65,535 and 65,536. Excel 2007 and Excel Services 2007 had a problem with a few numbers it doesn’t like … truly. A few numbers around the 65,535 and the 65,536
There are critical updates for Excel 2003, Excel 2002 (XP) and Excel 2000 plus Office for Mac Microsoft’s regular monthly patch release includes a patch for a problem in Excel. A ‘malformed’ worksheet could give access to the computer. Microsoft Office 2000 patch needs Service Pack 3 Microsoft Excel 2000
A neat little hack to add the Word 2007 and Excel 2007 icons to Sharepoint 2003. Wictor Wilén has a neat little trick to add the Word 2007 and Excel 2007 icons to Sharepoint 2003 when you upload .docx and .xlsx documents. He provides the two small GIF icons plus
Working with date values in Excel is not as easy as it sounds. Should you enter dd/mm/yy or mm/dd/yy? Do you enter slashes or dashes or dots? Pop-up Excel Calendar solves all the headaches by adding a pop-up calendar to your Excel Working with date values in Excel is not
From: Microsoft Microsoft Office Visio 2007, Every Picture Tells a Richer Story- a Microsoft Q & A Richard Wolf, general manager of the Microsoft Office Graphics Division, highlights new data visualization capabilities in the upcoming release of Microsoft Office Visio that will enable business and IT professionals to more easily
Here’s a list of the October 2006 security updates for Microsoft Office for Windows. There are five security updates for Microsoft Office this month, all of which are rated ‘Critical’ by Microsoft. Powerpoint for Windows and Mac See https://office-watch.com/kb?924163 PowerPoint 2000, PowerPoint 2002, PowerPoint 2003, Excel 2004 for Mac, Excel
More about random numbers in Excel. See Also El Patron de los Numeros Primos Sabotaging Random Numbers Getting truly random numbers into Excel Random Numbers in Excel
If anyone doubted Google’s interest in moving into the ‘office suite’ style applications, that doubt was erased by the announcement of Google Spreadsheet. GOOGLE SPREADSHEET If anyone doubted Google’s interest in moving into the ‘office suite’ style applications, that doubt was erased by the announcement of Google Spreadsheet. We’ve been
More details on the ‘request’ to update Excel after Microsoft lost a patent suit. (You’ll find lots of missing information in this article – we have asked many questions of Microsoft on this matter and received only short, ambiguous and incomplete responses.) Back in June 2005 Microsoft lost one part
Excel is one of the best tools around for working with numerical data sets, but it is also a valuable tool to utilize when working with sets of textual data. By Kara Monroe Excel is one of the best tools around for working with numerical data sets, but it is
There’s more than one way to get your Excel macro to run when there’s an event like changes to your worksheet. You can use a special macro name which tells Excel when to trigger that code. By Office Watch reader, Howard Tanner There’s more than one way to get your
We look at an interesting bug in both Excel 2002 (XP) and Excel 2003. Thanks to Bruce N for reminding us about an interesting bug in both Excel 2002 (XP) and Excel 2003. As Microsoft puts it: “multilevel subtotals for data in Microsoft Excel 2002 or Microsoft Office Excel 2003,
When an Excel list gets big and complex, the issue of finding data in it, and extracting information from it, becomes important. We look at how to filter an Excel list to extract information from it. By Helen Bradley Excel is a great place to store lists and one reason
