keeps freezing

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

This error message is what I get when I open my excell
sheet and try to work on it. It freezes and won't let
me do anything with out a re-boot. It's only this Excel
sheet.
 
I saw your post yesterday and I guess you got no help. Now my suggestion is
a bit of a shot in the dark, but try this:

First, before you open the problem file, check to see if the problem is
caused by a macro. Do this by opening Excel but NOT opening the file, then
go to TOOLS>MACRO and then click on security. Then click on HIGH. Setting
the security to high will turn off any macros (unless signed and trusted).
Then open the file and see if you still have a problem. If the problem went
away, then continue with my instructions below.

In Excel, with that workbook open, hold the Alt key and press F11 to open
the Microsoft Visual Basic Editor. Look in the list that you will probably
see on the left side, where it will say VBAProject(filename) where your
file name will appear within the parenthesis. If there is a plus sign next
to VBAProject(filename), then click on it to expand. Also click to expand
where it says "Microsoft Excel Objects" and then double-click where it says
"ThisWorkbook".

Look then to see if there is any sort of code typed in the screen on the
right. The right hand screen should be totally blank unless you are already
familiar with this and have written event code here. Delete any code you
find. Then save. Then close the VBA editor.

If you found code and deleted it, then you probably solved your problem.

HTH
Richard Choate


This error message is what I get when I open my excell
sheet and try to work on it. It freezes and won't let
me do anything with out a re-boot. It's only this Excel
sheet.
 
To follow on my other message, you could be having a problem with an add-in
that you have installed, especially a 3rd party add-in. They have these for
all kinds of things, from pdf writers to Avery labels to Excel utilities to
you-name-it. Any one of these could be the problem. If you have them, I
would start turning them off/uninstalling them, one at a time, until you no
longer have the problem.
HTH
Richard Choate

This error message is what I get when I open my excell
sheet and try to work on it. It freezes and won't let
me do anything with out a re-boot. It's only this Excel
sheet.
 
Back
Top