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 |
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 |
All times are GMT +1. The time now is 08:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com