Thread: Slow validation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Slow validation

Hi Denis

XL2007 is slower than Xl2003 in calculating..

If you are applying validation to whole columns, then the range you are
using is 16 times as large as it was under 2003.
Perhaps you could apply the validation to a smaller range that covers the
area you are likely to use.


--

Regards
Roger Govier

"Denis" wrote in message
...

I bought a new pc (LG), a new windows Vista with a new Office 2007.

I used to use the VALIDATION for the entries in a collumn.

The program with office 2003 and windows XP works perfectly and rapidly

Now for example:
To move the cursor from a cell with validation to any other cell, it takes
12 secondes. Between cells without validation, it's very fast (normal).

Is somebody could help me (English or French)?

Denis