Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel Locks Up

Posted on 2009-03-29
10
Medium Priority
?
1,113 Views
Last Modified: 2012-05-06
Excel usually works fine for me. But it locks up sometimes. I can usually work with other windows applications after it happens.

This tends to offur while working with large spreadsheets and/or after rapid keystrokes.  Sometimes it seems that i might be typing too fast.....

Task manager indicates that up 50% of CPU while in hold pattern.. Have 3 gm ram, fast machine etc.. Its not the hardware..

Are there any tricks to help excel snap out of it?  Sometimes it happens without intervention.  I  typically try (1) escape key;  (2) break key; (3) working with other applications for a while... Sometimes they work.   Other times the only remedy is to force shutdown using task manager.  That usually results in lost work.    

Any suggestions would be appreciated.


0
Comment
Question by:BW999
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 13

Expert Comment

by:gonzal13
ID: 24014615
Did you try to remove the program through the control panel and re-install it?
0
 
LVL 6

Expert Comment

by:WizardWill
ID: 24014636
What version of office are you using also have you got the latest service pack
0
 
LVL 16

Expert Comment

by:warturtle
ID: 24014735
Check for unneeded programs in the startup and get rid of them. Secondly, check to make sure that you don't have any viruses that are running in the background and consuming memory. You can download MalwareBytes Anti-Malware from http://www.malwarebytes.org/ and do a scan with that after updating it.

Hope it helps.
0
How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

 
LVL 81

Accepted Solution

by:
byundt earned 900 total points
ID: 24014754
Excel 2003 is not able to use more than 1 GB of RAM. This issue, its consequences and workarounds are discussed by Charles Williams at http://www.decisionmodels.com/memlimitsc.htm


One other thing you might try is to rename your toolbar file. Renaming it forces Excel to create a new one the next time it launches, thereby resetting your *.xlb toolbar file to factory specifications. You do this while Excel is not running, such as by renaming your *.xlb toolbar file to *.old. This file, which always exists but may be hidden, is frequently corrupted. If you have tried reinstalling Office or repairing an existing installation, any toolbar corruption problems remain because the installer won't reset the toolbar file.

After renaming the toolbar file, Excel notices during launching that it doesn't have one and creates a new copy to factory specs. Mine (for Excel 2003) is called Excel11.xlb and is located in the XLSTART folder. Your name and location may be different, so please search for it (and there may even be more than one on the computer).

The XLSTART folder is most often located in two places:
C:\Documents and Settings\your Windows log-in name\Application Data\Microsoft\EXCEL\XLSTART
C:\Program Files\Microsoft Office\Office 11\XLSTART              This path is for Excel 2003. Earlier versions have a different number after Office
IMPORTANT: The Application Settings folder is hidden by default--so you won't be able to see it unless you choose the option to "Show hidden files and folders" in Windows Explorer's Tools...Folder Options...View menu item

Brad
0
 

Author Comment

by:BW999
ID: 24015196
The excel installation is up to date.  Run deep virus scans showing no problems.  
The decision support site has some interesting ideas that I'll check out.

Will reset the toolbar.  I've been customizing it lately and perhaps it got corrupted...

The lockup occurs infrequently and more or less randomly (different computers and/or spreadsheets..)   This may be just part of your normal background noise in windows etc...  

I was mostly looking for tips on whether there are any special keys that I could press to unlock it.  or any software utilities that could help to revive it after it is locked.

One  is locked up right now and I dont want to loose it!.




0
 
LVL 16

Assisted Solution

by:warturtle
warturtle earned 600 total points
ID: 24016940
There is something else as well that I am thinking about - are you working on documents on remote servers that might have been shared with other users?? If yes, please try downloading a local copy and making changes to it. MS Office would normally put locks on the files, as far as I understand.
0
 

Author Comment

by:BW999
ID: 24028650
That's a good point.  I sometimes have word or excel documents open that are stored on another computer in our home network.   The problem has occurred in those instances, but other times as well.

My latest idea is that it has something to do with my mouse (or use of it).  Sometimes it runs a bit wild with I'm smoking through spreadsheet.  Sometimes I'll hit combinations of buttons, wheel, and/or keystrokes that cause excel to zoom in/out quickly or do something else strange.  That definitely is a risky situation for lock-up.

I also noticed that the problem generally does not happen when I am using the toggle button on my thinkpad instead of external mouse.  That definitely slows me down.

Look into upgrading the mouse, mouse driver, and/or mouse windows settings.  Any suggestions?

It's locked up again!

Thanks,

BIll
0
 

Author Comment

by:BW999
ID: 24028675
P.S.

I noticed that outlook has trouble accessing my address book when excel is locked up in the background.

Also saw somewhere that activating outlook's journal feature (tracks open excel files) can cause problems with excel performance.  I'll try turning that off too..

Bill
0
 
LVL 16

Expert Comment

by:warturtle
ID: 24028865
Do you have any addins installed into your office? like Xobni?? or any others?? If you do, try disabling them for a start.
0
 

Author Comment

by:BW999
ID: 24067870
I have a few addins (PuPV6, Microcharts, FastExcel, others).  I 'll try tinkering with those.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

704 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