Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Slow respone to key strokes
I have a file that is fairly basic. 6 short worksheets (8 column x 20 rows
max on each). The file is 4,116 KB. For some reason one of the worksheets has a very slow respone time to key strokes. Any ideas as to what would cause this slow response? -- Thanks for any help! Keith |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Slow respone to key strokes
That sounds like a pretty large file for such a small amount of data/formulas.
Do you have any pictures in the workbook? Do you have any event macros in the workbook? Do you have lots of conditional formatting? I bet if you copy each sheet and paste|special formulas into new worksheets in a different workbook, the speed will increase and the size will go down. If you have macros, you'll have to copy them, too--sames with names, page setup and all those things that you won't remember until you do it the second or third time! And here are a couple of sites that discuss slow performance. The first is by Charles Williams and the second by David McRitchie: http://www.decisionmodels.com http://www.mvps.org/dmcritchie/excel/slowresp.htm And one more thing... Do you have Google Desktop Search installed--or any of those search programs? Try disabling them to see if that helps. Keith wrote: I have a file that is fairly basic. 6 short worksheets (8 column x 20 rows max on each). The file is 4,116 KB. For some reason one of the worksheets has a very slow respone time to key strokes. Any ideas as to what would cause this slow response? -- Thanks for any help! Keith -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow Excel Navigation with Up / Down Arrow and slow scrolling | Excel Discussion (Misc queries) | |||
Is there a way to move between worksheets using key strokes only? | Excel Discussion (Misc queries) | |||
Chart Events - Trapping arrow key strokes | Charts and Charting in Excel | |||
Nested function - what key strokes to save and return a value? | Excel Worksheet Functions | |||
go to - special - visible cells only - takes too many key strokes | Excel Discussion (Misc queries) |