Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
Hi,
It's really impossible to answer this question, it depends on not only how many rows but also how many columns, how large the file is and how complex the Subtotal command. One thing to consider, from my experience Pivot Tables are substantially faster at doing the same thing as the subtotal command. That is pivot table do subtotalling and faster. -- Thanks, Shane Devenshire "gboll" wrote: So if you are consistently sorting and subtotaling 100,000 rows of information what power should my computer have. It grinds for quite some time currenlty and I want to make sure I have enough horsepower to really grind this analysis out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting Large XML Files into CSV File via Excel | Excel Discussion (Misc queries) | |||
Converting Large XML Files into CSV Files for Excel | Excel Discussion (Misc queries) | |||
Searching large excel files | Excel Discussion (Misc queries) | |||
Excel Filtering doesn't work with large files | Excel Discussion (Misc queries) | |||
Using large excel files | Excel Worksheet Functions |