Tuesday, June 19, 2007

Microsoft Bus Driver should be loaded in your system before installing Realtek HD Audio Driver

Looked into a few sources and I thought the solution could be clearer.

To fix this follow these steps

  1. Open device manager in system properties
  2. Find a PCI device in the System Devices section that has a yellow exclamation mark next to it
  3. Right click on that device and click Update Drivers. This will install UAA Audio Bus.
  4. Proceed to install Realtek HD Audio Drivers.

Excel Spreadsheet Takes 100% CPU to Open and Close

Today at work someone's excel took 5 minutes to open a 500KB .xls file. The CPU load was at 100% while opening. Same when closing. The issue was there was a lot of VB macros in that file. Every time it opens, Excel creates several *.emf files in %temp%. When I opened the temp folder, there were over 5000 *.emf files from 0 to 3KB.

To solve this problem, simply browse to the user's temp folder by typing %temp% in a run dialog box and delete all *.emf files. While you are at it, delete any file starting with "mso." Make sure Excel or any other program for that matter is closed. Since we don't want any application to be using a file that we are about to delete.

It's probably a good idea to periodically clean out the temp folder with the windows utility or manually.