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.