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

Make Emergency Call From Mobile Phone

Not many people aware that we are actually can make an emergency call from the mobile phone by dialing 112. In Malaysia, the emergency call number for GSM phone is 112. This number is pre-programmed in all GSM phone and also can be called in the jungle if there is no available line.

Once incidents happen, we need help immediately from relevant parties but what if we are at outstation and we don’t know the department number for that area? Hence, making a call to 112 the operator will help you make a report to your nearest department you are so that will reach you within a short period.

For more information please refer to Wikipedia - Emergency Telephone Number.

Remove Window Default Share Drive

Windows is configured to share all your hard drive as defaulted, but how do you remove this default sharing?

For those who are using windows XP, you may find that the system will automatically share all your disk drive as defaulted after the windows successfully installed. With this defaulted sharing feature, you may not have privacy if you are working in office or join network group with your housemate, because they may access your computer to copy or read file without getting your permission by simply typing "\\[destination ip address]\c$".

* c$ - By keying the "$" the unauthorized person is able to access the network drive.

Well, you know the door is opening, but how do you lock it? There is not only 1 solution to solve this but the most efficient and effective way for me is to change the registry.

1. Click Start, type Regedit in the Run.

2. Select HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanManworkstation\Parameters.

3. Move your mouse to right panel and right click to select *New\DWORD.

4. Name it AutoShareWks, and change the value "0".

*If AutoShareWks not created.

5. Restart your PC.

Hope this may help you to protect your privacy.