Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi core and pivot table woes
I had a 2007 excel sheet with about 400,000 rows. Then i have a pivot table
that filters down to about 50,000 rows. When i sort or refresh, it goes into "Calculating PivotTable report for about 3 to 4 mins. The problem we built a new machine with dual quad core processors (8 Cores). Task man only show one of the 8 procs doing the calculations. Any tips or tricks to make this work or use all the Procs available? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table woes | Excel Worksheet Functions | |||
information on taking advantage of XL 07 & multi-core processors | Excel Discussion (Misc queries) | |||
Multi-Sheet Pivot Table Too Large | Excel Discussion (Misc queries) | |||
Pivot table woes. | Excel Worksheet Functions | |||
pivot table multi line chart | Charts and Charting in Excel |