Cursor moving slow in excel

Please help. I must have unintentionally changed a setting. In Excel 2003,
when I move from cell to cell holding the top/bottom/left or right arrows
down, it moves very slow from cell to cell. Also when editing a cell, it
moves very slow to move within that particular cell with the arrow keys.

I haven't changed anything in options, etc. It just started doing it. The
cursor works fine when moving it in Word. I have re-booted 3 times. I have
tried another keyboard. I don't know what else to do. Scroll lock is off.

Also, I don't use User Defined Functions.

Thanks,

--
rlaf


Hello Everyone,

I have a macro in Excel 2003 and I saved that file in Excel 2007 (xlsm) version; however, the code is working very very slow. In excel 2003 it used to take me 1-2 minutes but now its taking over 20 mins.

Below is the code that I have in excel 2003. it copies the data from another tab of the same spreadsheet. Please suggest if I need to make any changes in the code to make its speed better.

Thanks!
Kapil

Sub CopyColC()

Dim Sht1Rng As Range
Dim Sht2Rng As Range
Dim B As Range
Dim D As Range
Dim mainSht As Worksheet
Dim backUpSht As Worksheet
Dim CellToCopyTo As Range

'Compares the ID cell in both worksheets to each other

Set mainSht = Worksheets("Main")
Set backUpSht = Worksheets("Backup")

Set Sht1Rng = Worksheets("Main").Range("B6",
Worksheets("Main").Range("B65536").End(xlUp))

Set Sht2Rng = Worksheets("Backup").Range("B6",
Worksheets("Backup").Range("B65536").End(xlUp))

For Each B In Sht1Rng
Set D = Sht2Rng.Find(B.Value, LookIn:=xlValues)

'If same value found in col B of "Backup" sheet then copy col C
If Not D Is Nothing Then
            
            backUpSht.Cells(D.Row, 3).Copy
            
            Set CellToCopyTo = mainSht.Cells(B.Row, 3)
            CellToCopyTo.PasteSpecial xlPasteValues
                     
End If

Set D = Nothing

Next B

Application.CutCopyMode = False

End Sub


I am having a problem that I cannot move around in excel 2002 with the arrow keys on the keyboard. I am using a computer that is new to me and I am not sure what the previous person has set up/done to excel!!!

If I try and move using these keys nothing happens.

I am able to use the mouse to move to different cells but this is so time consuming.

Has anyone come across this before?

Any advice on rectifying this would be most appreciated,

Thanks in advance,

Mark

when moving a row to a new place it takes seconds before i can do the next.
calculation is off. In excel 2000 the same worksheet does not have this
problem

In Excel 2003 I used to

1. Select a chart by shift-clicking on it (i.e. selecting without entering
editing mode)
2. Move the chart around by holding control and pressing cursor keys

This was especially useful when I needed to exactly position a chart.

In Excel 2007 I have been unable to achieve the same effect -- any
suggestions?

-Gerhard

I have just updated from Microsoft 2000 to Microsoft 2003. My first attempt
to use Excel has failed.

When trying to edit a particular cell on an old spreadsheet I pressed f2
then placed the cursor where I wanted to add some more data.

However, it only allowed me to type a couple of words & then the cursor
moved itself to another position, a few words further on, not to the end of
the line. When I moved the cursor back to where I wanted it & tried typing
again it just moved away again. The cell in question contains only words, no
sums or formulae.

I'm sorry if this is a fundamental question but I'm a computer illiterate
trying hard to understand this new technology.

I want to move a worksheet to a different workbook. I use the move and copy tool and a dialog box appears advising that the sheet can't be moved because it has less columns and/or rows than the target workbook. It reads that you can copy and paste, but that defeats the purpose of the tool. I can't remember that this ever happened in Excel 2002. Is this new in 2007 and can it be overcome?
Thanks,

Alan

I would like to move an image in an Excel form, but not sure if the VBE
application is equipped to do this. Does the functionality to define the path
and rate of movement of an object on a VB form exist in Excel 2003 VBE?
--
Regds
Andy_G

Hello, I’ve lately been struggling to speed-up a process of compressing data in cells by utilizing the Range.SpecialCells method. Everything works fine in Excel 2003 and 2007 with execution time of 15 to 20 seconds. Very recently I upgraded to Excel 2010 (32 bit) and over there the execution takes 4 minutes and in some cases even much more. I have a couple of questions in that regard:

Would an upgrade to Excel 2010 (64 bit) dramatically speed up the process at least to the speed I experienced with Excel 2003 / 2007? From my understanding, an upgrade should be considered when dealing with 100,000’s of rows. The range my code covers is only B20:MC3020.Is there a parallel method to compress the data in Excel 2010 that I'm unaware of? I tried applying the data compression through an array which I found in MrExcel forum. The speed remains the same in any of the Excel versions.
This is the code I’m trying to use:

	VB:
	
 Data_Compress_Test() 
     
    Application.ScreenUpdating = False 
    Application.Calculation = xlCalculationManual 
     
    With Sheets("5 Day") 
        .Range("10:10,19:19").ClearContents 
        .Range("B20:MC3020").SpecialCells(xlCellTypeConstants, 2).ClearContents 
        .Range("B20:MC3020").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlToLeft 
         'Compressing the data
    End With 
     
    Application.Calculation = xlCalculationAutomatic 
    Application.ScreenUpdating = True 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
SpecialCells(xlCellTypeConstants, 2).ClearContents is needed because the cells in the range are results of formulas which are being pasted special (values only) from another sheet. The result can either be 1 or "" (double quote signs). There’s no problem with the execution of that line however.

This is the line that causes the HUGE delay in 2010:

	VB:
	
.Range("B20:MC3020").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlToLeft 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
All I want to achieve is to delete blank cells in between the 1’s in each column and compress the 1’s to the left as a consequence. I attached a file that contains the code and some sample data ready for a test run. I would really appreciate if somebody can test how fast it runs in Excel 2010 (64 Bit) and shed light on a possible solution to the low speed performance if an upgrade to 64 Bit won't help.

I am trying to make a chart that in Excel 2003 takes no time at all to
display. It can involve up to 20 different series (maybe 500pts each). I
end up editing specific series to a common color, and I turn labels and lines
on or off depending upon consecutive data. Again, Excel 2003 took this with
no problems and showed the edits quickly. Excel 2007 locks up!! It can take
5 minutes for the color palette to show up!!

I am currently testing/comparing Excel
2002 (Windows XP)
and Excel 97 (Windows NT). I have a
spreadsheet with 50-
75 Formula Arrays (i.e. =sum(if
(A1:A5="A",B1:B5))) that
seems to be taking a very long time to
calculate. My
process is to turn calcs off (application.calc
=
xlmanual), then insert some new data,
then turn calcs back
on (application.calc = xlautomatic).
In my testing process, I have found that it
takes 5-10
times longer in Excel 2002 compared to
Excel 97!!
Does anybody have any suggestions on
why this is happening
and what I could do to fix it?

Does anyone know why macros that ran ok in Excel 2000 now take forever in Excel 2003? This affects any kind of macro and turning Auto Recalculation On and Off does not help.

Does anyone know why macros that ran ok in Excel 2000 now take forever
in Excel 2003? This affects any kind of macro and turning Auto
Recalculation On and Off does not help.

--
ebeltran

I am currently testing/comparing Excel
2002 (Windows XP)
and Excel 97 (Windows NT). I have a
spreadsheet with 50-
75 Formula Arrays (i.e. =sum(if
(A1:A5="A",B1:B5))) that
seems to be taking a very long time to
calculate. My
process is to turn calcs off (application.calc
=
xlmanual), then insert some new data,
then turn calcs back
on (application.calc = xlautomatic).
In my testing process, I have found that it
takes 5-10
times longer in Excel 2002 compared to
Excel 97!!
Does anybody have any suggestions on
why this is happening
and what I could do to fix it?

Hi all...first time post.

Can anyone tell me where Excel 2003's "Tools > Options > Edit > Move selection after Enter" command is in Excel 2007 please?

It allowed you to dictate the cursor movement after entering data in a cell.

Excel 2007 currently moves the cursor down to the cell below. I want it to stay in the cell I've just entered the data into.

Thanks in advance.

I created a worksheet in Excel 2003 where with protection I can force editing
in only one cell. The cursor only rests in that cell, so that when typing
you don't have to first move the cursor to that cell. In an older version of
Excel, I can't do that. I can have it tell me my entry is invalid for the
cell my cursor is in. Is there a way in earlier versions to force the cursor
to only rest on a specific cell? Validation, drop-down box type things? I
can't think of the word.
Thanks, Bob

In excel 2002, after i enter data the cursor will move after a couple of
seconds. I don't press any key. (not enter or tab). Does anyone know how to
turn this off?

I searched to see if a thread was already started, but could not find one.

Problem is, when i press page up, or page down the screen moves down one
page, but the cursor doesn't go with it. If, after i press page down, i
press the down arrow key, the cursor winds up in the cell just beneath the
cell i began with before i pressed page down the first time.

I have looked everywhere i can think of to resolve this myself. Can anyone
please help?

Thanks!

Dan

When I try to shade a portion of a column in excel or a word table, sometimes
the cursor moves so quick to the end of the column that I can't get it to
stop where I want the shading to stop.
This does not happen in every table or every spreadsheet.
Is there a setting somewhere that I'm overlooking??
Thanks for your help!!

I need to know how to stop the Excel Cursor from moving down one cell after a click selection. I turned OFF the cursor move selection after pressing Enter int he Advanced features function under Excel options. But I am NOT using the Enter button, I am using the click feature of the mouse. So how so I stop this from happening??
I am using a SelectionChange trap in VB to trap the cell location and then if ti is within my cell restraints, I am allowing a calendar to popup and when the date is selected, the cursor should just unactivate in a cell period is what I am ultimately after. I do NOT want the date popup to show up again when the cursor moves down to the next cell at all. Here is my code. I went back to the double click to get the cursor to quit moving around. But I really want to have just one click select liek the commented code does. Cursor movement is the issue here.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

If ((Target.Row >= 6 And Target.Column = 7) Or (Target.Row >= 6 And Target.Column = 8) Or (Target.Row >= 6 And Target.Column = 9)) Then
frmCalendar.Show
End If
End Sub

' I prefer this code to be used but the cusror moves to the next field when this is used.
'Private Sub Worksheet_SelectionChange(ByVal Target As Range)

'If ((ActiveCell.Row >= 6 And ActiveCell.Column = 7) Or (ActiveCell.Row >= 6 And ActiveCell.Column = 8) Or (ActiveCell.Row >= 6 And ActiveCell.Column = 9)) Then
' frmCalendar.Show
'End If
'End Sub

hello VB experts,

I have weekly meeting on inventory status with internal customers, with more than 20 columns & rows in Excel spreadsheet. Sometimes it was difficult to focus their attention as people having questions on different Part Number jump from one row to another. I am looking for a code or AddIn where the active row (the row where my cursor's position is at) will be highlighted each time I move the cursor. I have tried the popular "HiLite.xla" and the recent "RowLiner.xla" but not what I want. Greatly appreciate if anyone can help me on this.

Thanks very much in advance.

In Excel VBA Userform, how to copy the text from textbox automatically when the cursor is being moved from the textbox. And when i put CTRL+V then the copyed text has to be pasted. Please help me in this.

I'm not a new Excel user, by any means, but everything I've done in Excel has been VERY simple. I'm largely self-taught, which means I probably call things by the incorrect name lots of times. Please bear with me.

I am creating a simple form in Excel for users to fill out electronically and e-mail back to me.

I need the cursor to move only to specified cells (skip some of the cells) when the tab key is pressed. Can this be accomplished with a macro? (I hope it's even easier than that.)

Thanks!

I have many animated charts that run smoothly in Excel 2003. The charts are animated via VBA code. Now when I run them in Excel 2007, the animation is much slower, and often jerky. I have a new laptop with the latest processors, so it cannot be CPU speed that is the issue ... it just seems that what ran brilliantly and quickly in Excel 2003 now is quite slow. File size is not an issue either.

Any ideas at this frustrating aspect .... great animations in Excel 2003 now are very much slower. It seems like Excel 2007 is a big step backwards in performance.

Is there a way to highlight ( in a color ) the cells as you move the cursor around in Excel? For instance, if you are in one cell, it would be in a color that you pick. When you move the cursor up, down, left, or right, the cell that you go to would then turn that color