Speed up Excel Start up (FASTER EXCEL)

Ever wondered why your excel startup so slow, even if you're working on the best motherboard and processor available in the market? Tried many things but no success. Try this, although this is one of the trick or might be the only reason but if it is, then you'll save a lot of your time.

One of the expected reason is Excel's toolbar file which tends to grow very big and this toolbar file is loaded when excel starts up. The extension of this excel toolbar file is XLB, default location is "Application Data\Microsoft\Excel\" and normal size is 10 to 90 KB. Problem arises when this size reaches in megaBytes(MB).

Solution: Delete all xlb file from these locations:
Windows 98 Users --> "C:\Windows\Application Data\Microsoft\Excel\excel*.XLB"
Windows 98SE/NT/ME Users --> "C:\Windows\Profiles\USERNAME\Application Data\Microsoft\Excel\excel*.XLB"
Windows 2000/XP Users --> "C:\Documents and Settings\USERNAME\Application Data\Microsoft\Excel\excel*.XLB"
Windows 7 Users --> "C:\Users\USERNAME\AppData\Microsoft\Excel\excel*.XLB"

Assumptions: USERNAME is your system user name and User Profiles or Operating System is installed on drive C. Please change the values accordingly.

WARNING: However, XLB file is re-created automatically but you'll lose all of your toolbar customizations (or say personal menu settings).


VBA Macro:
Sub Speedup_Excel()
Dim fso
On Error Resume Next
Set fso = CreateObject("Scripting.FileSystemObject")
'Delete excel.xlb. If not exists goto next
fso.DeleteFile VBA.Environ("appdata") & "\Microsoft\Excel\excel*.xlb"
'Clean up
Set fso = Nothing
End Sub







Comments

Post a Comment