Windows Secrets logo

 

 

   
       
   
Windows Secrets Newsletter • Issue 127 • 2007-10-18 • Circulation: over 275,000

Fred Langa's Wallpaper of the Journey
Get Fred Langa's wallpaper for your desktop
Our editor-at-large, Fred Langa, is back from a 5-month motorcycle tour of the U.S. and Canada. Through Oct. 24, all paid subscribers are eligible for a bonus download, Wallpaper of the Journey — 25 high-quality images by Fred that you can use as desktop wallpaper. Free subscribers can get the bonus by upgrading to the paid version. And anyone can purchase the entire set of images for U.S. $9.95. Get it today! —Brian Livingston, editorial director

 • Paid readers: download the bonus
• Free readers: upgrade to get the bonus
• For everyone: purchase the download
   
     
Contents
 TOP STORY: Free software on USB enables portable computing
KNOWN ISSUES: Get official and unofficial fixes for Excel
WACKY WEB WEEK: Go a little ape with human Donkey Kong
LANGALIST PLUS: Part four: WU, Symantec suite can slow PCs
PC TUNE-UP: Good ways to protect your sensitive data
PATCH WATCH: Internet Explorer 7: missing in action or not?
YOUR SUBSCRIPTION: How to change your address or unsubscribe

    
   

For links to every topic in this issue, scroll down to the Index

    
   
ADS
Speed up your PC without new hardware   Speed up your PC without new hardware
 PC Pitstop's Free Optimize Scan will automatically diagnose problems with your PC and give you a custom report detailing issues that are hurting your PC's performance. Scan your PC for free today!
 www.pcpitstop.com

Be more productive in Microsoft Outlook   Be more productive in Microsoft Outlook
 Save time in Outlook with these powerful utilities: Attachment Save — automatically save attachments when e-mail arrives, Schedule Recurring E-mail — send regularly occurring e-mails, and more. See our entire list of 36 powerful add-ins on our Web site.
 www.SperrySoftware.com

Backup your data with ZipBackup   Backup your data with ZipBackup
 Finally, a backup program that's easy to use. ZipBackup's Wizard makes backups a snap for beginners. Filtering, scheduling, and disk spanning make it a powerful tool for experts. For a limited time, Windows Secrets readers receive 25% off.
 www.zipbackup.com

See your ad here

    
   
TOP STORY

Free software on USB enables portable computing

Scott Dunn By Scott Dunn

USB flash drives are good for more than just storing and transferring files — with the right software, your flash drive can become a tiny computer.

Fortunately, you can find plenty of great software that not only runs on a USB flash drive, but is also completely free.

To maximize your flash drive, get a suite

In Part One of this article in the Oct. 11 issue, I described the fastest USB flash drives, which are necessary for portable software to run well. Once you have the USB drive you want, and you've installed the necessary software, you can plug the drive into any machine and have all the applications and data you need at your fingertips.

In this issue, I'll tell you about the best free software for flash drives. I'll also explain how to use a flash drive with relative security on any computer.

These days, portable software (sometimes called flash-drive compatible software) is available from an array of sources. In many cases, these products are assembled into suites. The major offerings are from PortableApps, winPenPack, and U3. You can also download and install individual portable applications wherever you find them.

Having tested all the major offerings, I recommend that you combine two sources to get the best free software for your flash drive:

• Use the Portable Apps suite. PortableApps has a solid collection of open-source and free software. I found its menuing system, however, to be less than the best.

• Add the winPenPack menu. Fortunately, a highly customizable program launcher from winPenPack can easily be installed along with a suite of software from Portable Apps.

PortableApps

For ease of installation, there's nothing like downloading a whole collection of applications that are designed to run from a flash drive. The suite from PortableApps suite comes in two editions: Standard (260MB) and Lite (105MB).

The free software in the Standard edition includes portable versions of an office suite (OpenOffice), a browser (Firefox), an e-mail client (Thunderbird), a calendar and task manager (Sunbird), antivirus software (ClamWin), instant messaging (Gaim), and a game (Sudoku). The Lite version is almost the same, but replaces the many functions of OpenOffice with AbiWord, a word processor.

The suite also includes a built-in backup function and a launching menu that appears in the system tray. (On many computers, you must first start the launcher manually through Explorer after inserting your flash drive.) If you only want this menu and the backup utility, you can download just that from PortableApps as well; it consumes only 1MB when installed.

Although PortableApps has its own special format, you can add any app that's on your flash drive to the PortableApps launch menu (regardless of format). To do so, click Options, Refresh App Icons. Unfortunately, this function adds all .exe files to the menu, whether you want them all there or not.

To download any or all of these portable software programs, visit the PortableApps site.

winPenPack

A different collection of portable applications is available from winPenPack, an Italian company. The company's site offers plenty of free applications grouped into various suites or collections (in both English and Italian). The site features its own customizable, pop-up menu launcher, which I found superior to PortableApps' offering. You can download the menu system by itself or as part of a software collection.

Just as PortableApps offers Standard and Lite suites, winPenPack provides a variety of software packages. The company calls these Essential, 1GB, Expert, School, and Web. The site also includes instructions for assembling your own personal set of apps. You can see a list of the applications in these suites by visiting the Doc/Help page and clicking Applications Lists. Then click the suite whose contents you want to see.

Because the product originates in Italy, you may need to apply an English language pack after installation.

A few of the winPenPack apps I tried seemed underpowered, but the sheer breadth of available product categories (Office-style applications, graphics, Internet, multimedia, security, system utilities, and more) was impressive. And I liked the ability to customize the hierarchy of menus and submenus in the program launcher, which you can use with any folder or application, not just winPenPack collections.

For information on creating your own set of portable applications, visit the personal winPenPack page. To install the launcher separately from any other software, visit the download page. Change the language widget in the upper-right corner to "English" if it's set to "Italian."

If you don't find winPenPack's launcher to your liking, another free, customizable pop-up launcher is PStart, from Pegtop software.

U3

If you have a U3 drive and are satisfied with the available U3 software, installing a U3 app is as simple as clicking the U3 icon in the system tray (the area of the taskbar near the clock) and clicking Download Programs. The list makes it easy to spot the free programs from trial or shareware versions.

Do-it-yourself

A final (and more laborious) option is to use your favorite search engine to find apps that are designed to run from flash drives. Popular sites for portable freeware include Andrew Lee's Portable Freeware collection and the portable freeware page of the NedWolf site. SnapFiles also has listings for such products, but these are mainly small utilities rather than mainstream applications.

How to reduce the risks of flash computing

If you plan to use your flash drive with any public computer, you're exposing yourself to a variety of risks. Using a public computer is never 100% safe and private, since a PC used by others might have keylogging software capturing your passwords and other data. However, you can take some steps to limit the dangers from viruses, keyloggers, and loss of the drive itself.

Use antimalware software. The risk of acquiring viruses, spyware, or other malware from a public computer is high, so take care to install one or more antimalware products on your flash drive. Antimalware programs are available in all of the collections discussed above. You can also find other portable antimalware products online.

In addition, once you return home, you should use any virus scanner that's installed on your desktop machine to scan the flash drive before using any application on it.

Don't use online banking on a public PC. If you log on to a banking application that allows money to be transferred from your account to payees, this is just what keylogging software is looking for. Either carry a laptop that you regularly scan for spyware, or find some way other than an Internet café to do your banking remotely.

Protect your privacy. Privacy on a public computer is also a concern, especially if you're working with sensitive documents. One strategy for protecting your data is to use a portable encryption program like TrueCrypt, as discussed in the Aug. 2 and Aug. 16 newsletters.

Another option is to use an archiving program that can encrypt the compressed files it creates. For example, the program IZArc2Go fills that bill and is designed for flash drives as well.

To use the files you encrypted, you'll have to copy them from the encrypted folder to work on them. When you're finished with the work files, copy them back to the encrypted folder. Then destroy the work copies using a shredder utility, such as CyberShredder or Ultrashredder.

Make backups. Finally, protect yourself against accidental loss of the drive itself by making backups of its contents. If you're making the backup to your desktop system, you can use whatever software you have on that system (including any that might be built into your version of Windows). In addition, backup utilities are found in all the portable-application collections discussed earlier.

Flash drives make it easy to take both your work and applications with you wherever you go. Although they're not as secure as taking a laptop with you, they're much easier to transport. With the right precautions, you can reduce your risks and get the ultimate in portable computing.

Readers Richard Cobb and "Brad" will each receive a gift certificate for a book, CD, or DVD of their choice for their help in researching this topic. Have a tip about Windows? Send us your tips via the Windows Secrets contact page.

 Scott Dunn is associate editor of the Windows Secrets Newsletter. He is also a contributing editor of PC World Magazine, where he has written a monthly column since 1992, and co-author of 101 Windows Tips & Tricks (Peachpit) with Jesse Berst and Charles Bermant.

Contents  Index

   
   
ADS
Get your product seen by 275,000 readers   Get your product seen by 275,000 readers
 Does your company offer a product or service? Now you can place an ad in the Windows Secrets Newsletter and be seen by more than 275,000 active buyers of PC hardware and software. Bid as much or as little as you like to get the ideal ad placement.
 www.WindowsSecrets.com

See your ad here

    
   
KNOWN ISSUES

Get official and unofficial fixes for Excel

Brian Livingston By Brian Livingston

Despite the hotfix that Microsoft recently released for Excel 2007, as I described on Oct. 11, some math errors that you should know about still lurk in both Excel 2007 and Excel 2003.

I'll bring you up to date and explain how you can get better results from Excel.

Baier and Neuwirth offer Excel math add-ins

In a nutshell, this month's patch for Excel 2007 corrects a bug that treats numbers close to 65,535 as if they were 100,000. To get the fix, see the Oct. 9 entry in Microsoft's official Excel blog.

Even with the hotfix, however, both Excel 2007 and Excel 2003 give slightly wrong — and, in some cases, extremely wrong — answers to some floating-point calculations. I'll give you some examples below. First, let's discuss an independent solution to the problem.

Those who want more accurate floating-point math than any version of Excel supports should download a statistics program called R. This is open-source software that was originally written by Robert Gentleman and Ross Ihaka ("R & R"), who now work with about 20 researchers around the world to maintain the code.

The R program, in turn, can be used with Excel if you install various add-ins by Thomas Baier and Erich Neuwirth called RExcel, rcom, and R(D)COM. Windows Secrets contributing editor Woody Leonhard recommended this in his Oct. 4 column on the Excel problem.

In last week's article, I rounded off R(D)COM to R, which resulted in me mistakenly saying R was authored by Baier and Neuwirth. Ouch! This floating-point stuff really is hard!

Erich Neuwirth kindly e-mailed me the following explanation:
  • "Thomas Baier wrote rcom and R(D)COM, both of which allow you to use R as an embedded library in any Windows program supporting the COM (Component Object Model, not the serial port) interface. I wrote RExcel, which embeds R into Excel and allows you to use R functions as if they were native Excel worksheet functions.

    "So, yes, R can be used as a floating point library for Excel, but it is much, much more. Most computational statistics research nowadays is done using R."
For more information about R, or to download it free from R-Project.org, visit the R-Project site.

For more information about the Excel add-ins, see Baier and Neuwirth's R(D)COM page and the RExcel installation instructions.

Some Excel 2007 bugs also affect Excel 2003

I mentioned last week that Excel 2007's problem with 65,535 was reported to also affect Excel 2003, but that Microsoft wasn't being clear about this. Reader Charlie Woodall explains that this particular bug is present in Excel 2003 only if Microsoft's "Save as Excel 2007" converter has been installed:
  • "The Excel bug [involving 65,535 in Excel 2007] does not affect the older versions of Excel. However, for those who have applied the Office 2007 Compatibility Pack to older versions of Office, there are two files that are affected by the bug. The two affected files, excelcnv.exe and oartconv.dll, must be replaced by build 12.0.6042.5000. These files are part of the Office 2007 Compatibility pack. The bottom line is that the Excel bug affects the file format converter and not the older Excel versions."
Even if you install Microsoft's October 2007 patch to Excel 2007 and to the file converter in Excel 2003, however, other math errors remain in both products. Microsoft's acknowledgement of the 65,535 problem has resulted in new attention being paid to these errors by commenters in the official Excel blog:

• The dec2hex( ) function gives wrong answers (see comments 5178648 and 5205563);

• Calculations involving a result of 0.1 are slightly off (5192535);

• The trunc( ) function changes the value of calculations that are already truncated (5372326).

Woodall confirms these problems and clarifies what Microsoft's October 2007 hotfix does and does not cure:
  • "You are correct that the bugs addressed in the 4 links affect Excel 2003. They also affect Excel 2007. The hotfix that was issued the other day did not fix these bugs in either Excel 2003 or Excel 2007. The hotfix seems to have fixed the [65,535] calculation bug that affected only Excel 2007 (and the file format converter). In effect, the hotfix makes Excel 2007 calculations agree with Excel 2003 calculations [involving 65,535]. ...

    "Microsoft should definitely fix the problems with the dec2hex( ) and dec2oct( ) functions. However, the error 4.1 – 4 = 0.0999999999999996 [which should result in 0.1] is due to the inaccuracy in floating point calculations and is probably not considered a bug by Microsoft."
The difficulty of representing numbers like 0.1 and 0.01 in crude binary fractions is the reason the world has statistics programs like R. If Microsoft won't build precision into Excel, other people will.

For his part, RExcel developer Neuwirth has his own dirt on the Redmond spreadsheet app:
  • "My main concern with Excel is its inconsistent handling of rounding: int(1000–2^–41) and quotient(1000–2^–41,1) never should produce different values, and that is what Excel does. Int(1000–2^–41,1) also never should be negative, but Excel gives a negative result. These are more than floating point issues, this is a logical problem."
UPDATE 2007-10-19: Erich Neuwirth e-mailed us to say that his comment, "Int(1000–2^–41,1) also never should be negative...", should have said, "Mod(1000–2^–41,1) also never should be negative...".

What to do: I recommend that you install the hotfix to Excel 2007 and to Excel 2003's "Save as Excel 2007" converter, but you shouldn't expect this to solve every Excel calculation error. Just because a number comes out of a computer — or a program comes out of Redmond — it ain't necessarily reliable.

Readers Neuwirth and Woodall will each receive a gift certificate for a book, CD, or DVD of their choice for sending comments we printed. Send us your tips via the Windows Secrets contact page.

 The Known Issues column brings you readers' comments on our recent articles. Brian Livingston is editorial director of WindowsSecrets.com.

Contents  Index

   
   
TELL A FRIEND

How you can share this information

 We love it when you send your friends links to our articles. But please don't forward your copy of our e-mail newsletter to people, which subjects us to spam complaints. Instead, simply suggest that your friends visit this issue's permanent Web address, shown below. A complete index at the bottom of the Web page provides you with hyperlinks to any article you'd like to recommend.

The address of this issue is http://WindowsSecrets.com/comp/071018

 		   
   
EDITOR'S BOOKSHELF

Windows Vista Secrets Get the tips you need about Windows Vista
The all-new Windows Vista Secrets helps novices and experts alike understand Microsoft's latest operating system. "To really appreciate what is in Vista, you almost need to read through the leading book on the product, Windows Vista Secrets, by Brian Livingston and Paul Thurrott," writes Rob Enderle, principal analyst of the Enderle Group, in TechNewsWorld. "It's 595 pages of things you can do with this product — most of which you probably wouldn't have discovered for some time, let alone right at first." Check the book out now for tips you can use.
More information: United States (B&N) / Canada / Elsewhere

Spam-Proof Your E-Mail Address, 2nd Ed. Spam-Proof Your E-Mail Address, 2nd Ed.
This 32-page e-book by Brian Livingston gives you step-by-step instructions that can prevent 97% of the spam that would otherwise clog an e-mail account. You could call it "Livingston's Spam Secrets." The PDF e-book is the result of months of experiments and tests we conducted. We now receive little or no spam to the addresses we used as guinea pigs. These tests show that you can make your e-mail addresses invisible to spammers, not just battle an ever-growing flood. The methods we describe work with Windows, Apple, and Linux and don't require any filters or block lists — but you can use those in addition to the book's techniques, if you wish. More info

    
   

Contents  Index

   
   
WACKY WEB WEEK

 Go a little ape with human Donkey Kong

Human Donkey Kong  Almost everyone has heard of Donkey Kong, the 1981 arcade in which the heroic Mario makes a laborious climb to rescue his sweetheart Pauline while dodging moving obstacles from a barrel-hurling gorilla. (Ah, the good old days!)

This remake takes the game to new levels of realism — and reality — by having humans fill the roles. After viewing the video, you might be tempted to ask: just who is the donkey in this game? Play the video

Contents  Index

   
   
INDEX

The following topics appear in the free version

TOP STORY   Free software on USB enables portable computing
  To maximize your flash drive, get a suite
  How to reduce the risks of flash computing
   
KNOWN ISSUES   Get official and unofficial fixes for Excel
  Baier and Neuwirth offer Excel math add-ins
  Some Excel 2007 bugs also affect Excel 2003
   
WACKY WEB WEEK   Go a little ape with human Donkey Kong
   
You get all of the following in the paid version

LANGALIST PLUS   Part four: WU, Symantec suite can slow PCs
  Delete Windows Update files to free space
  Symantec security suite slows performance
  PrintScreen key saves screenshot to Clipboard
  In the Canadian Rockies en route to Toronto
   
PC TUNE-UP   Good ways to protect your sensitive data
  Three new security tools from Lavasoft
  How MS's Malicious Software Removal Tool works
  Lightning brings calendar functionality to Thunderbird
  Notepad2 — supercharged replacement for Notepad
   
PATCH WATCH   Internet Explorer 7: missing in action or not?
  IE 7 is back on Microsoft Update
  Sun Java update offers OpenOffice, too
  A tentative approval for OE/Windows Mail patch
  Fixes may help you with SharePoint patching
  IE 7 flaw with 'mailto' and similar protocols
  Oracle releases 51 patches for databases
   
Paid subscribers can access all old and new paid newsletter content
Make a contribution to support our research into Windows and you'll immediately be able to read and search through scores of valuable articles. In addition, paid subscribers are entitled to download valuable content that we license for you at least once every calendar quarter.

To upgrade, simply make a contribution of any amount you choose.
If you do this by Oct. 24, 2007, you'll instantly be sent the full, paid version of today's newsletter.

To upgrade to the paid version of the Windows Secrets Newsletter, please visit our upgrade page. Thanks in advance.

   
   

Contents  Index

   
   
YOUR SUBSCRIPTION

The Windows Secrets Newsletter is published weekly on the 1st through 4th Thursdays of each month, plus occasional news updates. We skip an issue on the 5th Thursday of any month, plus the week of Thanksgiving and the last two weeks of August and December.

Publisher: WindowsSecrets.com LLC, Attn: #120 Editor, 1700 7th Ave., Suite 116, Seattle, WA 98101-1323 USA. Vendors, please send no unsolicited packages to this address (readers' letters are fine).

Editorial Director: Brian Livingston. Editor-at-Large: Fred Langa. Associate Editor: Scott Dunn. Contributing Editors: Susan Bradley, Mark Edwards, Woody Leonhard, Ryan Russell. Research Director: Vickie Stevens. Program Director: Brent Scheffler. Managing Editor: Virginia Culler. Editorial Assistant: Diane Korngiebel.

Trademarks: Microsoft and Windows are registered trademarks of Microsoft Corporation. The Windows Secrets series of books is published by Wiley Publishing Inc. The Windows Secrets Newsletter, WindowsSecrets.com, LangaList, LangaList Plus, WinFind, Security Baseline, Patch Watch, Perimeter Scan, Wacky Web Week, the Logo Design (W, S or road, and Star), and the slogan Everything Microsoft Forgot to Mention all are trademarks and service marks of WindowsSecrets.com LLC. All other marks are the trademarks or service marks of their respective owners.

 HOW TO SUBSCRIBE: Anyone may subscribe to this newsletter by visiting our free signup page.

WE GUARANTEE YOUR PRIVACY:

1. We will never sell, rent, or give away your address to any outside party, ever.
2. We will never send you any unrequested e-mail, besides newsletter updates.
3. All unsubscribe requests are honored immediately, period.  Privacy policy

HOW TO UNSUBSCRIBE: To unsubscribe from the Windows Secrets Newsletter,
 Copyright © 2007 by WindowsSecrets.com LLC. All rights reserved.

Contents  Index