Excel 2007 arrow keys VERRRRY slow

[Guest]

I have a file in Excel 2007 (in 2000-2003 format) that has ~25000 lines with
2 columns and NO FORMULAS. My arrow keys move like they are stuck in the mud,
and page-up and page-down delays a few seconds before moving. Filesize ~9MB.
I have another ~26MB file with thousands of formulas, MANY tabs, formatting,
charts, etc. and it functions perfectly fine (as well as can be expected from
Excel 2007!!). Any thoughts?? Any settings to tweak?? I've done a disk
cleanup with no improvement. I wouldn't think defrag would matter beacause my
~26mb file is fine.

 

[Jim Rech]

I'll suggest what everyone is thinking - is there a
Worksheet_SelectionChange or a Workbook_SheetSelectionChange macro running?
I can't think of anything else. If you want to zip up and send me the
workbook I'd be interested in seeing how it behaves for me.

Oh, if you start in safe mode (Start->Run "Excel.exe /s" [no quotes, there
is a space before the slash]) do you still have the problem?

 

[Dave Peterson]

Do you have any shapes on that worksheet?

Maybe hidden????

Option Explicit
Sub testme()
Dim shp As Shape
MsgBox ActiveSheet.Shapes.Count
For Each shp In ActiveSheet.Shapes
shp.Visible = True
Next shp
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Guest]

no macros!
re: safe mode: identical SLOOOOOW performance!
--
dh13134

I'll suggest what everyone is thinking - is there a
Worksheet_SelectionChange or a Workbook_SheetSelectionChange macro running?
I can't think of anything else. If you want to zip up and send me the
workbook I'd be interested in seeing how it behaves for me.

Oh, if you start in safe mode (Start->Run "Excel.exe /s" [no quotes, there
is a space before the slash]) do you still have the problem?

--
Jim

I have a file in Excel 2007 (in 2000-2003 format) that has ~25000 lines
with
2 columns and NO FORMULAS. My arrow keys move like they are stuck in the
mud,
and page-up and page-down delays a few seconds before moving. Filesize
~9MB.
I have another ~26MB file with thousands of formulas, MANY tabs,
formatting,
charts, etc. and it functions perfectly fine (as well as can be expected
from
Excel 2007!!). Any thoughts?? Any settings to tweak?? I've done a disk
cleanup with no improvement. I wouldn't think defrag would matter beacause
my
~26mb file is fine.

 

[Guest]

no shapes or anything else hidden. previously, i had 20-30 other tabs with
very similar info in them. i have since combined them into my ~25000 line
sheet and deleted the other tabs. i'm sure there is nothing else in/on the
sheet.

 

[Guest]

i'll zip & send. Thanks!
--
dh13134

I'll suggest what everyone is thinking - is there a
Worksheet_SelectionChange or a Workbook_SheetSelectionChange macro running?
I can't think of anything else. If you want to zip up and send me the
workbook I'd be interested in seeing how it behaves for me.

Oh, if you start in safe mode (Start->Run "Excel.exe /s" [no quotes, there
is a space before the slash]) do you still have the problem?

--
Jim

I have a file in Excel 2007 (in 2000-2003 format) that has ~25000 lines
with
2 columns and NO FORMULAS. My arrow keys move like they are stuck in the
mud,
and page-up and page-down delays a few seconds before moving. Filesize
~9MB.
I have another ~26MB file with thousands of formulas, MANY tabs,
formatting,
charts, etc. and it functions perfectly fine (as well as can be expected
from
Excel 2007!!). Any thoughts?? Any settings to tweak?? I've done a disk
cleanup with no improvement. I wouldn't think defrag would matter beacause
my
~26mb file is fine.

 

[Jim Rech]

Dale sent me the file and it turns out there were a few shapes in it. Over
20,700 pictures to be specific. All scrunched up with a width of zero.
Deleting them fixed everything and reduced file size by a factor of 6. I
guess what's surprising, or maybe not, is how the pictures degraded Excel
2007 performance compared to 2003. That's progress!

 

[Guest]

Hi Jim
I was getting ready to post your solution today, but I think you explained
it better than I could. Thanks again for you help in solving this.

BTW, REAL PROGRESS! - you're right!! I've also noticed that my (primitive)
macro on another sheet now takes 10-12 hours, where it took 45 minutes in
Excel2000. Although it is nothing but simple repetition, my times have still
increased to the point where they are useless!.

But that's another story for another post. Again, thanks for your help.
--
dh13134

Dale sent me the file and it turns out there were a few shapes in it. Over
20,700 pictures to be specific. All scrunched up with a width of zero.
Deleting them fixed everything and reduced file size by a factor of 6. I
guess what's surprising, or maybe not, is how the pictures degraded Excel
2007 performance compared to 2003. That's progress!

 

[Dave Peterson]

Glad you fixed the problem, er, part of his problem.

Dale sent me the file and it turns out there were a few shapes in it. Over
20,700 pictures to be specific. All scrunched up with a width of zero.
Deleting them fixed everything and reduced file size by a factor of 6. I
guess what's surprising, or maybe not, is how the pictures degraded Excel
2007 performance compared to 2003. That's progress!