Excel weird behavior

[a7yvm109gf5d1]

OK, according to the system info I have Excel version 11.0 build 6560.
This seems to be the latest version.
The workbook size is 5577.5KB.
It has 37 worksheets.

Yesterday I lost the ability to edit directly in a cell in one sheet,
but the "edit in cell" option is selected. I can edit in-cell in all
other sheets.

The thing is the mouse scroll wheel doesn't scroll the sheet, even if I
use cursor keys the sheet doesn't scroll. I can't use "pick from drop
down list" anymore. Excel even gave me a graphics bugs yesterday as the
cell bounding box went all over the place except around cells and the
sheet looked like the video card's memory was faulty. I should have
print screened it...

I have a bad feeling that the workbook is somehow corrupted and will
eventually no longer function properly. It is a huge inventory system
and it would be a nightmare to lose the latest changes to the system.

Is there a "db doctor" kind of tool to check for weird stuff in excel?

I will try to copy the whole sheet to a new book and copy it back, but
this scares me, is Excel flaky or what?

 

[Guest]

Of course, in a situation like this, work only with a copy of your file.
What I would do is rename the sheet and copy it out to a new file. If it
works ok there, then copy it back as the original name. Keep both sheets in
the file until you find out that the new one is working ok, then delete the
renamed one. But of course, you always have a backup to go back to because
you're working with a copy...right?

Vaya con Dios,
Chuck, CABGx3

 

[a7yvm109gf5d1]

"But of course, you always have a backup to go back to because
you're working with a copy...right? "

Yup, pretty much. The sheet in question has some named ranges and
copy/paste doesn't copy that info over so the rest of the book breaks
when I paste the new data over.
But I think that's the only way to go for now. Sigh...

 

[Guest]

Yeah, sorry, I've had a couple of Excel Sheets "break" recently and the only
fix I was able to come up with was this type of major surgery......no real
explanation as to what was wrong, but they worked again after this treatment.
In some cases, one can save a skeleton of the real working file, and when a
break occurs, simply go and paste the new data in place in the old file and
you're back on the road.

Vaya con Dios,
Chuck, CABGx3

 

[a7yvm109gf5d1]

Well, FWIW, I fixed mine just now by doing a window ->unfreeze panes
and then freeze it again. It's "normal" again. I don't really see the
connection but it's fixed for now!