How To Remove Excel 2007 Add-In

Sometime you may know what other add-in will be installed when you installing an application to the computer system. Therefore the problem comes to when you uninstall that particular application from our computer but the add-in not being uninstalled.

Recently it happen to me where the add-in install to the Excel 2007 is not automatic uninstall together with its parent application. Hence, when every time I run open Excel the error message is shown to me indicate that there is incorrect path for the add-in.

To solve this you need to manually remove the add-in.

1. Open the Excel option page. (Excel Icon – Excel Option button at the bottom)

2. On the Excel option page, select Add-Ins from the left pane and then look for the add-in that causes an error.
Eg: If the add-in type is “Excel Add-Ins”, then select the add-in type in the Manage drop down and click Go button.

3. On the popup window uncheck the Add-In you want to remove and click OK. (If that add-in is invalid, the add-in will automatically remove. However, if valid add-in Excel just disable it and you can enable it back anytime in future).

Turn Off Annoying PC Beep Sound

Did you ever hear the sound “beep” in the office? This is because the computer running or executing the application with error.

This is more happened for those running in virtual machine, because in physical machine we have installed sound card and driver therefore the machine will not trigger the beep sound. However, in virtual machine in order to get high performance and normally will not include sound device and therefore beep sound will be triggered if error occur.

You can follow these steps to disable it in Vmware

1. Right click [My Computer] and then select [Manage].
2. Under [Computer Management] select [Device Manager] to highlight it.
3. From the Menu bar select [View] then click [Show Hidden Devices]
4. Expand the Menu for [Non-plug and play drivers]
5. Double click on the [Beep] item and go to [Driver] tab and click [Stop].

Recreate Desktop Shortcut Icon To Quick Launch Bar

Some time you may not accidentally deleted the Desktop shortcut icon in the quick launch bar. If really do so then how to re-create it ?

You can follow this step below to re-create the icon for Windows XP.

Step 1
Copy and paste this code to the noteopad

[Shell]
Command=2
IconFile=explorer.exe,3
[Taskbar]
Command=ToggleDesktop

Step 2
Select save as to save the file and name it as [Show Desktop.scf]
Take note the file must save in .scf

Step 3
Cut the file to below path
C:\Documents and Settings\Username\Application Data\Microsoft\Internet Explorer\Quick Launch

* Username = the name that currently logon to the Window

Why The Download Speed Is Vary From The Package

Some people may find that the download speed appearing in the Download engine is varying from the package they subscribed. For an example, the speed appears in the download engine is 60KBps but the package taken is 384Kbps, impossible the broadband service can be slow down few times of the original speed.

Actually it is not. Please read carefully one appear as KBps (Kilo bytes per second) and another 1 appear as Kbps (Kilo bits per second). For the network providers they use to advertise Kbps, therefore it confusing to those who are not familiar with IT.

To prove that you really getting the promise services, you can do this check

1 Byte = 8 bit
1 KB = 1024 Byte

Calculation For 384Kbps
1. (384*1000)/8 = 48000 Byte
2. 48000/1024 = 46.9 KB

Meaning that 384Kbps package you actually getting 46.9 KBps download speed.

How To Send Large Attachment Via Email

Many mail providers will limit the file size of the attachment, so that they can control the network performance. But what if there is no other solution that we really have to send a large attachment via email to whom in other country?

There are some mail provider can help you solving this problem. They act as a file server and allow you to upload whatever attachment to the server and then send a notification email on behalf of you to the recipients with a download link to download the attachment.

This is very convenient and the link only available for the person you invited has the link to download the attachment.

Here are the two providers I use to send large attachment.

YouSendIt
TooBigForEmail