problems with filtering locking program

J

judi

All of a sudden today, excell started doing something
weird. When I try to do a filter (either simple or
advance/custom) I get a box that opens and says "fixed
objects will move". I can not close this box. Hitting
escape does not work. The only way to get out of the loop
is to go to task manager and close the program.

I have never seen this before and have been using excell
for many years. Currently using version Excell 2000

Doe anyone know what is causing this and how to fix it?

Thanks if anyone can help.
 
J

Jan Karel Pieterse

Hi,

Is this just with one file or with any?

If the former, I suspect there are objects on the sheet
you try to filter (might be a cell comment too). Try if
removing all objects and comments helps.

Regards,

Jan Karel Pieterse
Excel TA/MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top