Excel 2007 arrow keys VERRRRY slow

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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?
 
no macros!
re: safe mode: identical SLOOOOOW performance!
--
dh13134


Jim Rech said:
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
dh13134 said:
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.
Click to expand...
Click to expand...
 
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.
 
i'll zip & send. Thanks!
--
dh13134


Jim Rech said:
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
dh13134 said:
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.
Click to expand...
Click to expand...
 
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!
 
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


Jim Rech said:
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!
Click to expand...
 
Glad you fixed the problem, er, part of his problem.

Jim said:
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!
Click to expand...
 
Back
Top