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.
6 comments:
Hei - this did the fix for me... I did have to wait 5 min to open Excel document, now it is 10 secs
There are many files on my PC. But I missed all my excel files several days before. As luck would have it I could come back all my data. But what is more the software would assist in multifarious issues quite easily - Microsoft Excel this file is not in a recognizable format.
I had this happen and it drove me crazy! Turns out it was the Print Driver I was using. Close your Excel file, go to Devices and Printers and change your default printer to something other than what it is. Re open your Excel file and see if it does it. Hopefully that helps.
Hi to all, as I am really keen of reading this blog's post to be updated daily. It consists of pleasant material.
my site; how much should i weigh chart
Hi to all, as I am really keen of reading this blog's post to be updated daily. It consists of pleasant material.
My site: how much should i weigh chart
I absolutely love your blog and find most of your post's to
be what precisely I'm looking for. Does one offer guest writers to write content for you?
I wouldn't mind writing a post or elaborating on some of the subjects you write related to here.
Again, awesome web site!
Here is my blog :: how do you become a phlebotomist in california
Post a Comment