Solved

Excel 2007 hangs on Windows 7

Posted on 2011-09-15
7
350 Views
Last Modified: 2012-05-12
I have a user that was recently upgraded to Windows 7. Throughout the day, every 30 minutes on average, Excel will lock up and takes several minutes until it is responsive again. I was able to see this happen once and saw that the disk was getting hammered. It was showing 150MB/s going to the hard drive.

Now I am trying to find out why this is happening and more importantly how to fix it. Anyone seen this before or know where to start looking?
0
Comment
Question by:ryan80
7 Comments
 
LVL 30

Accepted Solution

by:
ded9 earned 500 total points
ID: 36545340
Could be an addin issue ...launch excel in no addin mode and check.

Click start and type ...  excel /safe

To disable or delete unwanted addin check this

http://office.microsoft.com/en-us/help/enable-or-disable-add-ins-in-office-programs-HA010034127.aspx


Can also try clean boot..

Launch excel in clean boot mode.

Clean boot process

Start-type - msconfig- click on startup tab- click disable all...then click services tab- put a check on hide all microsoft services ...and then click disable all....click ok and then restart the computer in normal mode.

If everything works fine in clean boot then enable five startup items and services at a time to find the faulty software.



Ded9
0
 
LVL 12

Author Comment

by:ryan80
ID: 36545354
Ok, I will start with this. I did forget to mention that this is a fresh install.
0
 
LVL 18

Expert Comment

by:hopeleonie
ID: 36545355
In most cases, add-ins are the cause Office programs.
Try to disable all add-ins in Excel on a test computer.

http://office.microsoft.com/en-us/outlook-help/enable-or-disable-add-ins-in-office-programs-HA010034127.aspx

You can also try this automatic fix:

http://support.microsoft.com/kb/280504/en-us

Try the Microsoft Fix it 50268
0
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 
LVL 2

Expert Comment

by:techdunes
ID: 36549052
Hi,

It can be problem with currup XLB file. Try this out.

Search for *.xlb file, once found either rename it (safer practice) or delete it. Make sure that all MS Office application or any Office files are closed before doing this.
Now reopen an Excel file. It will automatically create the new file.

Try this and do comment.
0
 
LVL 66

Expert Comment

by:johnb6767
ID: 36549521
"I was able to see this happen once and saw that the disk was getting hammered"

By what process, Excel.exe?
0
 
LVL 12

Author Comment

by:ryan80
ID: 36550316
yes, excel.exe

I found that there was a application called multimon installed on the computer that simulates a stretched task bar across two monitors. I read about someone experiencing a similar issue with a program that does the same thing. I have removed it and will see what happens.
0
 
LVL 12

Author Closing Comment

by:ryan80
ID: 36575230
Found the appliation that was causing issues this way.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now