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?

--
Steve Wolstenholme Neural Planner Software

EasyNN-plus. The easy way to build neural networks.
http://www.easynn.com

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
=================================


wrote in message
...
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?

--
Steve Wolstenholme Neural Planner Software

EasyNN-plus. The easy way to build neural networks.
http://www.easynn.com

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

Steve

On Fri, 21 Apr 2006 11:17:57 -0500, "Daniel CHEN"
wrote:

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.

wrote in message
...
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?

--
Steve Wolstenholme Neural Planner Software

EasyNN-plus. The easy way to build neural networks.
http://www.easynn.com

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


with @tiscali.co.uk


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

Steve

On Fri, 21 Apr 2006 11:17:57 -0500, "Daniel CHEN"
wrote:

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.

wrote in message
...
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?

--
Steve Wolstenholme Neural Planner Software

EasyNN-plus. The easy way to build neural networks.
http://www.easynn.com

On Fri, 21 Apr 2006 21:27:28 +0100, "Sandy Mann"
wrote:

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?


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


--
Steve Wolstenholme Neural Planner Software

EasyNN-plus. The easy way to build neural networks.
http://www.easynn.com

wrote in message
...

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


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


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

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk
..com

On Sat, 22 Apr 2006 00:01:29 +0100, "Sandy Mann"
wrote:

wrote in message
.. .

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


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


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

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.

--
Steve Wolstenholme Neural Planner Software

EasyNN-plus. The easy way to build neural networks.
http://www.easynn.com

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


with @tiscali.co.uk


wrote in message
...
On Sat, 22 Apr 2006 00:01:29 +0100, "Sandy Mann"
wrote:

wrote in message
. ..

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


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


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

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.

--
Steve Wolstenholme Neural Planner Software

EasyNN-plus. The easy way to build neural networks.
http://www.easynn.com

On Tue, 25 Apr 2006 20:28:21 +0100, "Sandy Mann"
wrote:

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?


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.


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

It's a mystery!

--
Steve Wolstenholme Neural Planner Software

EasyNN-plus. The easy way to build neural networks.
http://www.easynn.com