Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Beta Advanced Filter Performance
I am finding that the Advanced Filter on Excel 2007 Beta is extremely slow
when filtering moderate amounts of data (around 3000 lines). It is particularly slow when the criteria fields are cleared and operation can be up to 10 minutes duration. This is also a problem with Excel 2003, but much less so (normally up to 30 seconds), and can be minimised by eliminating all calculations in the database or by setting "calculation" to manual during the filter routine. I have transferred the database from its orignal Excel 2003 application and reconstructed it in Excel 2007 which helps, but the result is still impractical. Has anyone got any suggestions how this can be resolved or is it a limitation of the Excel software? -- Rhoodnkt |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Beta Advanced Filter Performance
Beta
"RHoodnkt" wrote in message ... I am finding that the Advanced Filter on Excel 2007 Beta is extremely slow when filtering moderate amounts of data (around 3000 lines). It is particularly slow when the criteria fields are cleared and operation can be up to 10 minutes duration. This is also a problem with Excel 2003, but much less so (normally up to 30 seconds), and can be minimised by eliminating all calculations in the database or by setting "calculation" to manual during the filter routine. I have transferred the database from its orignal Excel 2003 application and reconstructed it in Excel 2007 which helps, but the result is still impractical. Has anyone got any suggestions how this can be resolved or is it a limitation of the Excel software? -- Rhoodnkt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta | Excel Discussion (Misc queries) | |||
printing of text box in excel 2007 beta | Excel Discussion (Misc queries) | |||
deleting sheets in Excel 2007 ( Beta 2 ) | Excel Worksheet Functions | |||
Lost Excel 2000 VBA help after installing Excel 2007 Beta | Excel Discussion (Misc queries) | |||
Excel 2007 Beta 2 Bug Posts | Excel Discussion (Misc queries) |