cannot select any cells to complete formula

  • Thread starter Thread starter NickB
  • Start date Start date
N

NickB

I've got an weird Excel workbook that has several sheets.
If I create a "Summary" sheet to, say get the SUMs of the
cells in the other sheets, I have problems. I can
type "=SUM(", but when I try to select any cell in any of
the workbooks (except for one workbook), it says "Point"
down in the Status bar and just gives me a pointer and I
cannot select any cells. I can copy and paste a link from
any of the cells no problem. I can type in the full
formula with no problem. I ran this thru Open and Repair
in 2003 but still had the problem. There doesn't seem to
be any protection on. There are no macros. Except for
this, it seems as though I can do whatever I want with the
cells. If I copy all the cells into a blank worksheet, the
problem still occurs.

Two odd things:
1) I have no problems if I use 2003. This only occurs
when I use 2000 or 2002.
2) If I scroll down even one row, then it works fine (I
can select any cell).

Any ideas?
 
FWIW, I use XL2k and have no problem(?).
When I enter the formula "=sum(" then select a workbook/sheet and click
the 1st cell of the range the "Point" message displays but I have no
problem selecting the cells (either dragging across the range or
selecting non-contiguous cells).
As I said, I can't offer any solution other than to say it works in
XL2K.
 
Thanks RWN.

It appears to be just this one file. And to top it off, if I insert a
blank worksheet, it works fine.
 
Even if I delete all of the cells in the worksheet, it happens. If I
hit Ctrl+A then Del to delete all of the cells, but then Ctrl+A,
Ctrl+C and Ctrl+V onto a new sheet, the new sheet then has the same
problem (before pasting on the new sheet, it worked fine).
 
Nick;
I was hoping one of the experts here would jump to the rescue because
it's got me intrigued(!).
Looking back to your original post you were using the phrase
"Workbooks", did you mean "Worksheets"?
In other words, is it a case that you are attempting to sum cells from
different sheets to your Summary sheet in the same workbook, or sum the
values from separate worksheets in different books to the summary in
another workbook.
Was the workbook created in a different version and works ok in the
original, just screwing up in 2K (just looking for a hint).
Does it happen on any row/cell in the Summary" sheet or just the one
(you made reference to "Scrolling down one row" and having it work).
Obviously I'm flying blind here but I've tried to break my XL (usually
not too much of a problem for me!) but can't seem to get it to go wrong.
Tried hiding columns and selecting across the hidden column, playing
with some of the settings, protecting, formatting etc etc (no doubt
you've been down these roads).
Could be that you have a "corrupt" workbook.
Sorry I couldn't help.
 
Back
Top