How to make The "autofilter" function sort faster?

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

Guest

I have created a database/schedule/booking system, where i use 30 cloumns and
65000 lines of data that contains amongst other things; dates, weeknumbers,
weekdays and months. When i have chosen sort about 10 of the 30 possible
parameters, looking for blanks to fill with more data, the worksheet
functions at a very slow pace to say the least. I have removed the page break
from line 65536 (the last line) wich can lead to "lagging" and i have no
"conditional formatting" running. any suggestions what i can do to speed
things up?
--
Setup:

AMD Athlon64 X2 DualCore Processor 4400+ 2,3 GHz
2GB RAM
Windows XP Pro SP2
Office 2003 SP3
 
If you still have formulae in the sheet, you can fix the values using
<copy> then Edit | Paste Special | Values (check) | OK then <Enter>.

You can also turn the calculation mode to manual via Tools | Options |
Calculation tab - you can press F9 to recalculate. Remember to turn it
back to Automatic before you save.

Hope this helps.

Pete
 
Thanks a bunch!
--
Setup:

AMD Athlon64 X2 DualCore Processor 4400+ 2,3 GHz
2GB RAM
Windows XP Pro SP2
Office 2003 SP3
 
You're welcome.

Pete

Thanks a bunch!
--
Setup:

AMD Athlon64 X2 DualCore Processor 4400+ 2,3 GHz
2GB RAM
Windows XP Pro SP2
Office 2003 SP3







- Show quoted text -
Click to expand...
 
Back
Top