#1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Wrong Cell

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Daniel CHEN
 
Posts: n/a
Default Wrong Cell

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



  #3   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Wrong Cell

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


  #5   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Wrong Cell

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


  #6   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann
 
Posts: n/a
Default Wrong Cell

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a row to worksheet does not update cell references in another. blausen Excel Worksheet Functions 5 February 25th 06 09:14 PM
What is wrong with naming a cell as c? vezerid Excel Discussion (Misc queries) 4 January 31st 06 08:57 PM
copying cell names Al Excel Discussion (Misc queries) 12 August 11th 05 03:01 PM
Result in Cell is Wrong Lilbit Excel Worksheet Functions 1 June 23rd 05 05:19 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 04:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"