Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
What is wrong with naming a cell as c? | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
Result in Cell is Wrong | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |