Even after Service Pack 2, there are more fixes for Office 2007. Service Pack 2 has been out less than a week and already there are more fixes for Office 2007. These ‘hotfixes’ are temporary and ‘ not fully tested’ updates. Most are dated 30 April 2009 – only a
Official fix list for Excel 2007 SP2 both the summary and the complete list Here’s the official fix list for Excel 2007 SP2 both the summary and the complete list. We’ve published it here for easy reference instead of hunting around Microsoft’s web site and an Excel worksheet. This list
A trick for quickly printing part of a document, worksheet or slides plus when it does NOT work. Sometimes you just want to print part of a document, maybe a few paragraphs or many pages. One option available is to print the current selection. The basics are simple. In Word,
How to import any Twitter search into an Excel worksheet and update it automatically In our article Using Excel (the real one) to read Twitter we talked about importing your incoming and sent tweets into an Excel worksheet. You can do this to disguise Twittering from your boss however there
IF statement and some variatons – nested IF, CountIF and SumIF. by David Goodmanson IF a picture paints a thousand words, then how many words have 5 characters or more? The answer? Use the IF function. The IF function is a simple and easy-to-use function that can be widely applied
Details on Word & Excel updates from Office 2000 onwards plus Office for Mac. The usual security updates for Microsoft products this month include updates for Word and Excel from Office 2000 to Office 2007 plus Office for Mac. Security holes in Word’s text converter and Excel headline this month’s
Let’s have some INDEX() and MATCH() fun in our Lookup function series. by David Goodmanson On their own, the INDEX() and MATCH() functions are fairly straightforward but when they are combined they create a very powerful Lookup tool. Both functions have 3 parts to their arguments. INDEX(range, row_number, column_number) and
How to print a document when the paper sizes are different. On our new Twitter account we saw this question: “When I send an Excel file to someone, should I have to set it up so they can print? I don’t know the printer/size they use.” Part of that answer
Using Vlookup in Excel to work out tax, fees or commission from a table by David Goodmanson In part 1 we covered the basics of VLookup, let’s use it to calculate tax for a list of employees and their salaries. We’ve chosen this practical example because it contains a fixed
An UNpatched Excel security flaw is being exploited publicly. According to Symantec, there’s an unfixed Excel security hole which makes vulnerable Excel 2007 (with or without Service Pack 1) and maybe other versions of Excel. The Trojan is a variation on Mdropper which takes advantage of a ‘Remote code Execution’
How to format a Word or Excel document to print on someone else’s computer. On our new Twitter account we saw this question: ” When I send an Excel file to someone, should I have to set it up so they can print it? I don’t know the printer/size paper
Office Watch explains what can happen with Show Formulas in Excel and the simple fix. A slip of the fingers can make all your numbers disappear! An Office Watch reader wrote in a panic, her vital worksheet had gone crazy showing only formulas instead of numbers! She was the victim
Vlookup scares too many Excel users but it should not. David Goodmanson shows how easy and incredibly useful it can be. How can your grab a value from a separate Excel list and insert it into your current calculation? Vlookup or Hlookup is the main answer in Excel. We’ll
There’s a nifty BBC program all about the abuse of numbers. Excel is about numbers and numbers can be used or abused. In the media numbers are often abused for the sake of a headline or to push a certain product or ideology. There’s a nifty BBC program all about
From: Addintools Technology Addintools proudly announced the release of its universal and unique Ribbon Customizer for Office 2007 v4.10, designed for the flexible shaping and tuning of Microsoft Office 2007 Addintools proudly announced the release of its universal and unique Ribbon Customizer for Office 2007 v4.10, designed for the flexible
At the very end of 2008, Microsoft finally admitted to something Excel users had long suspected … that adding a lot of shapes to a worksheet can greatly affect Excel’s performance. At the very end of 2008, Microsoft finally admitted to something Excel 2007 users had long suspected … that
A global travellers guide to saving money and flying to interesting places on low cost airlines around the world. Regular travellers can get a nasty shock when they first fly on one of the new ‘low cost carriers’ (LCCs). Sure the fares are very low (US$15 or less at times)
More security patches for lapses in Microsoft products including various versions of Office from Office 2000 to 2007 plus some incarnations of FrontPage. More security patches for lapses in Microsoft products including various versions of Office from Office 2000 to 2007 plus some incarnations of FrontPage. As usual, we’ll list
Even after two years, the Lords and Members of Parliament in the UK can’t easily open Office 2007 documents. We explain the simple options available to the honorable members. Silicon.com is reporting that the UK’s Members of Parliament and the House of Lords are having trouble opening documents that are
It’s a simple question about ordering monthly data in Word – there’s many answers which give a glimpse into what you can do with Office. ” I want to have a monthly log of items, each month separated by a page or section break, but be able to “toggle” the
Microsoft has released a series of updated help files for Office 2007 programs. Microsoft has released a series of updated help files for Office 2007 programs. Each program has a separate download. In most cases the download includes updates for both the main user help file and the developers help
Soon Apple iPhone and iTouch users will be able to edit MS Office documents on a tiny but crisp screen. When Apple released the latest iPhone with direct support for Microsoft Exchange Server, it left the question of access to other parts of the Office suite. DataViz has announced that
‘Remote Code Execution’ is the phrase for August 08 updates for a wide range of Office products. August 2008 brings two security updates for Access plus Word, Excel, Powerpoint, Publisher and Office. It’s really a case of ‘once more around the roundabout’ with most of the patches fixing yet more
The Office 2007 can disappear to make more screen room available for your document – not only that but it does so intelligently. The Office 2007 can disappear to make more screen room available for your document – not only that but it does so intelligently. The ribbon can be
