Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Has SORT changed from 2003 to 2007?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Has SORT changed from 2003 to 2007?
<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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Has SORT changed from 2003 to 2007?
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Has SORT changed from 2003 to 2007?
Why not post what exactly you are doing?
If you sort an entire column, do realize that that is now over a million cells, not just 65000. But that's just a gues. As said, be more precise in telling us what you're trying to do. -- Kind regards, Niek Otten Microsoft MVP - Excel "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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tab colour can't be changed in 2003 Excel | Excel Discussion (Misc queries) | |||
Default charts changed from 2003 to 2007 | Charts and Charting in Excel | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
how do i prevent data from being changed when i sort excel column | Excel Worksheet Functions | |||
Changed Titled bar and now sort doesn't default to "Header Row" | Excel Discussion (Misc queries) |