Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Migrating to Excel 2007
I use the following code to filter data in Exel 2003.
Sheets("DevData").Range(SourceDev).AdvancedFilter Actiion:xlFilterCopy, CriteriaRange:=Sheets("FilterControl").Range(Crite rion2), CopyToRange:=Sheets("Results").Range("A10:BH10"), Unique:=False. Range("SourceDev") is about 50,000 row x 52 column. The macro works perfectly and returns results in about 2 to 3 seconds. The same code in Excel 2007 locks up. I've tried to running the same code in smaller workbooks with 2,500 rows and 52 columns. In 2003 I get results in 2 seconds in 2007 it takes 80 to 90 seconds. Any suggestions on code changes or setting that will help me. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Migrating to Excel 2007
Excel 2007
Try Action:=xlFilterCopy instead of Actiion:xlFilterCopy Tried 500 by 25 array. Did not notice any delay. http://www.mediafire.com/file/ymjmkdytozd/11_20_09.xlsm |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Migrating to Excel 2007
The code wouldn't compile with this error.
Depending on the computer's memory and processor, Excel 2007 may work nearly as quickly as 2003, or it may work vastly slower. Particularly on "large" data sets, where large is smaller than the capacity of 2003 worksheets. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Herbert Seidenberg wrote: Excel 2007 Try Action:=xlFilterCopy instead of Actiion:xlFilterCopy Tried 500 by 25 array. Did not notice any delay. http://www.mediafire.com/file/ymjmkdytozd/11_20_09.xlsm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Migrating Custom color palette from 2003 to 2007 | Excel Discussion (Misc queries) | |||
Migrating Office XP EXCEL files to Office 2007 | Setting up and Configuration of Excel | |||
Migrating Excel Data with inconsistent formats | Excel Discussion (Misc queries) | |||
migrating check boxes in Excel 2002? | Excel Discussion (Misc queries) | |||
Migrating from Excel 2000 to Excel 2003 | Excel Discussion (Misc queries) |