View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Has SORT changed from 2003 to 2007?

Hi

XL2007 is slower than 2003.
However, post your code and maybe someone can suggest methods to speed it
up.

--
Regards
Roger Govier

"Kierano" wrote in message
...
Well, quite simply, the issue is that a routine that normally runs in
about 2
minutes in Excel 2003 is falling over in Excel 2007. So far, by using a
combination of Esc and F5 via debug, I can get it to run partially but it
runs very s-l-o-w-l-y, hence my general question on whether anything has
changed between 2003 and 2007. Essentially, I'm using 2007 to run a
routine
that was created in 2003 and, of course, 2007 is backwards-compatible...?




"Niek Otten" wrote:

<which would explain this issue

What issue?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kierano" wrote in message
...
Hi,

Am encountering an error on SORT which previously has run fine - and
continues to run fine in Excel 2003, but fails in 2007. Have there been
any
changes made from 2003 to 2007 which would explain this issue?

Thanks,
Kieran