Wrong Cell

S

steve

When I open a frequently updated sheet the cursor always jumps to row
3442, column A.

Any ideas how I can get the behaviour back to normal and jump to the
last cell used when the file was closed?
 
D

Daniel CHEN

The initial cursor position is the position of the cursor when you save
(latest) the file.

You can press Ctrl+{End}to put the cursor to the last cell either before you
save or after you open the file.
--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Downloand
=================================
 
S

steve

Yes, I know what should happen but in this case the initial position
is always at row 3442 column A

Steve
 
S

Sandy Mann

Steve,

Is it possible that you have an Macro running on opening the workbook?

Does this only happen in this one workbook?

Did the workbook used to open OK and then suddenly started doing this?

If you copy the sheets to a new workbook does it still happen?

--
Regards

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk
 
S

steve

Steve,

Is it possible that you have an Macro running on opening the workbook?

No

Does this only happen in this one workbook?

Yes

Did the workbook used to open OK and then suddenly started doing this?

Yes

If you copy the sheets to a new workbook does it still happen?
Click to expand...

No. That fixes the problem but it would be nice to know why it
happened.
 
S

steve

My guess would be a corrupt workbook bu there is no way to prove it.
Click to expand...

It's happened again. Perhaps I need to do something else besides just
copying the sheet to a new workbook.

It's just one sheet 10 columns by about 3400 rows. Anew row is added
every day.
 
S

Sandy Mann

Sreve,

A search of Google turned up several similar posts with the cursor opening
up in the "Wrong" cell but no solutions.

Just out of curiosity, because if the high flyers in the other posts that I
found can't find the answer then I doubt if I will be able to but, does the
cursor still jump the cell A3442?

Save the file under a new name - presumably the cursor will still jump.

Delete row 3442. Where does the cursor jump to now? If it still jumps to
A3442 then I would think that it suggests that it is nothing to do with the
cell contents. If deleting Row 3442 stops the cursor jumping try entering
the data again manually. If that *cures* it then it may be that there was
something in the cell.

--

Sandy

In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk
 
S

steve

Sreve,

A search of Google turned up several similar posts with the cursor opening
up in the "Wrong" cell but no solutions.

Just out of curiosity, because if the high flyers in the other posts that I
found can't find the answer then I doubt if I will be able to but, does the
cursor still jump the cell A3442?
Click to expand...

It now jumps to D3465
Save the file under a new name - presumably the cursor will still jump.

Delete row 3442. Where does the cursor jump to now? If it still jumps to
A3442 then I would think that it suggests that it is nothing to do with the
cell contents. If deleting Row 3442 stops the cursor jumping try entering
the data again manually. If that *cures* it then it may be that there was
something in the cell.
Click to expand...


I've tried deleting all the rows after 3400 and it jumps to the empty
cell at D3465.

It's a mystery!
 
Top