Microsoft Office 2003 updates

Microsoft Office 2003

Microsoft have just announced Service Pack 3 for Microsoft Office 2003, which has prompted me to make sure that all my Microsoft Office applications are up-to-date.

What is a Service Pack?

A service pack (often abbreviated as SP) is a collection of updates, fixes and enhancements to a software application or operating system — such as Microsoft Office or Microsoft Windows — that can be installed at once. This makes the process easier and usually more reliable than installing a series of individual update patches, especially when you have to update more than one PC.

Service packs are usually numbered and will normally have to be installed in order, e.g. install SP1 before SP2; these are called incremental service packs, or sometimes service releases (SR). Often service packs are cumulative meaning that they also contain the contents of its predecessors, e.g. SP2 will include files from both SP1 and SP2.

Microsoft Office 2003 SP archive

Here are the service packs for Office 2003, certainly the applications that I use. The files can be downloaded directly from Microsoft (without requiring a Genuine Microsoft Software validation test).

Where offered, I recommend downloading the full file rather than the client which requires the original CD-ROM to be inserted; I find the full file is quicker to install.

Microsoft Office 2003

  • Office 2003 Service Pack 1 (SP1) (72.2 MB)
  • Office 2003 Service Pack 2 (SP2) (101.8 MB)
  • Office 2003 Service Pack 3 (SP3) (117.7 MB)

OneNote 2003

  • OneNote 2003 Service Pack 1 (SP1) (19.2 MB)
  • OneNote 2003 Service Pack 2 (SP2) (30.8 MB)
  • OneNote 2003 Service Pack 3 (SP3) (35.4 MB)

Project 2003

  • Project 2003 Service Pack 1 (SP1) (25.4 MB)
  • Project 2003 Service Pack 2 (SP2) (35.0 MB)
  • Project 2003 Service Pack 3 (SP3) (40.7 MB)

Visio 2003

  • Visio 2003 Service Pack 1 (SP1) (22.0 MB)
  • Visio 2003 Service Pack 2 (SP2) (34.4 MB)
  • Visio 2003 Service Pack 3 (SP3) (48.4 MB)

Other Office 2003 Service Packs can be found by searching the Microsoft Download Center (sic).

Download and backup

My advice is to download the files (broadband is highly recommended!) and then backup the files to CD-ROM or DVD so that you have then to hand the next time you need to reinstall Office 2003.

Installation

I ran the installation files in sequence by application, starting with the Office 2003 service packs and then moving on to the other individual applications.

The installer informed me which service packs had already been installed; in my case I had SP1 and SP2 already installed for each of these applications.

Office 2003 SP3 required a reboot after installation, the other updates didn’t.

Infinite Solutions

This is one of my favourite series of videos on YouTube: Mark Erickson’s Infinite Solutions.

The videos are packed full of great tips, from how to recharge batteries using other batteries, how to de-fogg goggles to how to find small dinosaur remains. Good useful, everyday stuff.

Also check out his website: Mark’s Infinite Solutions and the videos from Fatal Farm. A work of genius, if ever there was one.

Footnote

Lest there be any further confusion: the Infinite Solutions video tips are all for fun — don’t believe them, and please don’t go buying any electrical tape to stick batteries together, it could be potentially very dangerous.

DIY – a few tips

Someone holding a Bosch electric drill

These last few weeks I’ve been doing some DIY on the new house and thought that you might appreciate a few tips that I’ve learned.

  1. When drilling through bathroom tiles make sure that the drill isn’t set to the ‘hammer action’ setting.
  2. While preparing to drill through bathroom tiles — say for example in a shower cubicle — don’t stand in the wet cubicle shower tray in your bare feet while asking your wife to hand you the corded electric drill because invariably she won’t. Instead she’ll instruct you to first dry out the shower tray and then put on a pair of rubber-soled shoes.
  3. While drilling into a door — for example to add a coat hook — make sure you don’t drill all the way through the door as this doesn’t lend itself to a professional-looking finish.

And this one isn’t a tip just an observation: Unibond’s Ultimate Anti-Mould Shower and Bathroom Sealant (Ice White) smells like salt and vinegar flavour crisps.

Hoax e-mails and PC security

Computer mouse in chains

This week I received something in my e-mail inbox that I’ve not had in a while: a hoax e-mail ‘kindly’ forwarded to me by a friend or family member trying to help me and ensure that my hard drive wouldn’t be destroyed by the latest terrible virus.

Olympic Torch hoax

The hoax e-mail sent was the Olympic Torch hoax, had the subject “Please forward this warning to all of your contacts” and said

Importance: High

Be alert during the next few days: Don't open any message with an attached file called "Invitation", regardless of who sent it. It's a virus that opens an Olympic Torch that "burns" the whole hard disk of your computer.

This virus will come from someone who has your e-mail address; that's why you should send this e-mail to all your contacts. It's better to receive this message 25 times than to receive the virus.

DON'T open it , permanently delete it and re-start your computer immediately... This is the worst virus announced by CNN, it's been classified by Microsoft as the most destructive virus ever. The virus was discovered by McAfee yesterday, and there's no repair yet for this particular virus. It simply destroys the Zero Sector of the Hard Disk, where vital information is kept

How to spot a virus hoax

Virus hoaxes usually arrive in the form of an e-mail with instructions to pass this message on to all your contacts and they are often constructed using the same structure as the message above:

  • Opening paragraph about this dreadful new virus, what it does and why it’s the worst virus ever created.
  • More detailed information about how you will likely receive it (probably via e-mail) and why you should send this warning on to all your friends.
  • Information about what to do about it if you receive it (usually delete it and reboot your PC).
  • And a few references to some well-known IT companies to add weight to what they’ve said. Frequently mentioned are: AOL, CNN, McAfee, Microsoft and Norton/Symantec.

Anti-virus (AV) software companies do not send out warning e-mails (unless you’ve specifically signed up for a newsletter from them) asking you to pass on these details to your friends. AV software companies rely on two things to help you keep your PC clean of infection:

  1. that you ensure your anti-virus software is kept up to date, usually by recommending that you leave the software to automatically and regularly check for updates online — they regularly release updates that target the latest viruses, trojans and malware
  2. recommending that you practice a safe-internet routine whenever you are downloading files and/or e-mail attachments

If you receive a similar message that is warning you of the latest virus threat then please first check the Symantec Hoax site to see if your e-mail message is listed. The purposes of these e-mails is to create a sense of unnecessary panic and for you to spam your own friends!

Anti-virus software

If you don’t already have anti-virus software installed on your PC then I can thoroughly recommend AVG Anti-Virus Free 7.5.

I’ve been using it on my laptop for a few months now, and on my games partition on my main PC. One reason I like it is because it doesn’t hog system resources like other AV products do (such as Norton AntiVirus). The TweakGuides Tweaking Companion for Windows XP has an excellent walkthrough on how to optimize AVG for your system.

Another great thing about AVG, if you have a slow internet connection, is that the update downloads are generally very small. Yesterday’s update was 500 KB, today’s only 8 KB. So users still relying on a dial-up connection would be fine.

Anti-Spyware, Anti-Trojan

It’s often not enough to simply rely on your anti-virus software these days. I regularly scan my systems with AdAware SE (anti-spyware) and A-Squared Free (anti-trojan).

A regular scan once a week should be fine. Unlike anti-virus software and firewalls, you may install and run more than one package. I also allow the ZoneAlarm spyware scanner to run regularly, and Spybot Search & Destroy. The TweakGuides Tweaking Companion (mentioned above) also has a good section on using this software, I recommend that you download it and give it a read.

Firewalls

I also recommend that you make sure that you have a firewall running. A software firewall is an application that acts a bit like a bouncer for your network connection. It monitors all the in and out traffic making sure that only authorized traffic gets through.

A lot of people recommend using the built-in Windows XP firewall. I’m a little more cautious and as a long-time user of ZoneAlarm I’ve bought the ZoneAlarm Pro firewall which also adds extra e-mail and spyware monitoring capabilities. There is also a free version, which I’ve used very successfully.

Your surfing habits

One of the most important things for helping ensure that your PC does not become infected with malware — and I can’t stress this enough — is YOU! A few tips:

  • Get into the habit of regularly scanning your PC for malware (spyware, trojans, viruses). Put it into your diary, if you must (I do!).
  • Do not immediately open e-mail from recipients you do not know, especially if they have attachments. If you have an anti-spam filter then use it. The built-in one for Microsoft Outlook 2003 is excellent.
  • Get into the habit of manually scanning any download (downloads from websites, instant messenger contacts and especially from e-mails.
  • If you are in any doubt whatsoever about the security status of the file then delete it immediately and empty your Recycle Bin. If it was a genuine file from a genuine friend then they can always send it again if it was important.
  • And remember, please don’t spam your own friends! If you get a suspect e-mail check the Symantec Hoax site or simply search Google for a few of the keywords contained in the e-mail (such as Olympic Torch virus).

I hope that helps a few readers. And my e-mail inbox!

Creating a new toolbar in Windows XP

Desktop screenshot

Here’s something that a couple of people recently have asked about when they’ve seen my desktop, either on my laptop or on my home PC. Many of you may know about this; this is posted for the benefit of those who don’t.

You may see from the screenshot above that I have an extra toolbar on the right-hand side of my screen, which holds icons for my most commonly-used programs. The toolbar is always on top, meaning that when I’m running a maximized application (that is, full-screen), such as Outlook, the toolbar is still visible on the right-hand side of my screen.

The reason I do this is three-fold:

  1. I like to keep as few icons as possible on the desktop and Quick Launch bar
  2. It is quicker to access these applications from my new toolbar than via Start > Programs
  3. It is less system resource hungry than using an application-equivalent such as the Microsoft Office 2000 toolbar or Lotus SmartCenter.

Here’s how to do it.

1. Create a new folder

Create new folder

The first thing to do is to create a new folder. On my laptop I created this on the C drive, e.g. “C:\ShortcutsToolbar”. On my home PC I have 10 partitions, so have created this on drive H. It doesn’t really matter where you create it, so long as you remember where it is and it doesn’t get in the way of other applications.

2. Copy icons into the new folder

Folder of icons

Next, copy your favourite icons from the Start menu into the new ShortcutsToolbar folder. You can either right-click Start and select “Open All Users” and drag and drop icons from there, or hold down Ctrl and drag the icons from the Start menu itself.

If you know at this stage which order you’d like them to display, from top to bottom, you may rename them with a numeral prefix, e.g. 01 MS Money, 02 Psion SDK, 03 DigiGuide, etc. That way the icons will by default appear in numerical order.

As a rough guide a 1280 x 1024 pixels resolution screen will accept 25 icons, a 1024 x 768 pixels screen will accommodate 18. Don’t worry if you don’t fill up the toolbar at this stage, you can always drag icons onto the toolbar at a later stage.

3. Unlock the Taskbar

Lock the taskbar

Next, right-click on an empty part of the Taskbar and if there is a tick against “Lock the Taskbar” click on it once to unlock it.

4. Create a new Toolbar

Create a new toolbar

Right-click the taskbar again and select “Toolbars > New Toolbar…”. This will bring up the following dialog box:

New Toolbar dialog box

In this box browse to the location of your ShortcutsToolbar folder, select the folder and click OK.

5. Reposition new toolbar

Shortcuts Toolbar on Taskbar

Your new Toolbar will be created on the Taskbar. Click on the new toolbar and holding down the mouse button drag the toolbar off the Taskbar. You’ll be left with a free-floating box called ShortcutsToolbar, like this:

Free-floating Toolbar

Click and hold the title bar of this new window (click on the words ShortcutsToolbar) and drag the window until it docks on the right-hand side of the screen.

Docked toolbar

It’s not perfect yet, but we’re nearly there.

6. Customize toolbar

Toolbar options

Right-click on the newly docked toolbar to make the following adjustments:

  • View > Large Icons
  • Untick Show Text
  • Untick Show Title
  • Tick Always on Top

If you have not already determined the order of the icons by renaming them with numeral prefixes you can now reposition the icons using the good old fashioned drag-and-drop method.

7. Lock the Taskbar

Lock the taskbar

Right-click the Taskbar and select “Lock the Taskbar” once again.

8. That’s it

And that’s all there is to getting a customized, always-present toolbar for launching your favourite applications. There are a few icons that I always, always have on the toolbar, while there are others that get changed depending on what I’m doing. I also have developed my own guidelines for determining what sits on the ShortcutsToolbar, what sits on the Desktop, the Quick Launch bar and which icons are pinned to the top of the Start menu.

Similarly, you don’t have to have the toolbar on the right-hand edge of your screen. You could dock it to any other sides (top, bottom, left or right) or simply keep it docked to your Taskbar, as shown in step 5 above. Whatever suits you best, make it yours.

Desktop screenshot

Another quick tip: take a screenshot of it, just in case you need to reinstall Windows or you have to recreate the toolbar again sometime. That way you can always be sure of the order of the icons. You’d be surprised how quickly you get used to certain icons in a particular location. I’m often getting caught out moving between my laptop, home PC and work PC.

UPDATE: Removing a toolbar

Create a new toolbar

To remove a newly created toolbar, simply right-click the Taskbar, click on Toolbars in the context-menu and then click on the toolbar you wish to remove, clicking on the ticked item will de-select it.

This will simply remove the Toolbar from display, but the underlying folder will still be there so you can easily restore it at will.