 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007Excel 2007 arrow keys VERRRRY slow
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.  Signaturedh13134 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? SignatureJim >I have a file in Excel 2007 (in 2000-2003 format) that has ~25000 lines >with [quoted text clipped - 10 lines] > my > ~26mb file is fine. no macros! re: safe mode: identical SLOOOOOW performance! Signaturedh13134 > I'll suggest what everyone is thinking - is there a > Worksheet_SelectionChange or a Workbook_SheetSelectionChange macro running? [quoted text clipped - 18 lines] > > my > > ~26mb file is fine. i'll zip & send. Thanks! Signaturedh13134 > I'll suggest what everyone is thinking - is there a > Worksheet_SelectionChange or a Workbook_SheetSelectionChange macro running? [quoted text clipped - 18 lines] > > my > > ~26mb file is fine. 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 > 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, [quoted text clipped - 6 lines] > -- > dh13134 SignatureDave Peterson 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. Signaturedh13134 > Do you have any shapes on that worksheet? > [quoted text clipped - 22 lines] > > -- > > 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! SignatureJim > Do you have any shapes on that worksheet? > [quoted text clipped - 28 lines] >> -- >> dh13134 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. Signaturedh13134 > 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. [quoted text clipped - 34 lines] > >> -- > >> dh13134 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. [quoted text clipped - 40 lines] > > > > Dave Peterson SignatureDave Peterson
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.