| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why does adding columns slow down processing speed?
I have a workbook (using Excel 2002) that takes the data on the worksheet
"AllDealers" (960 rows x 112 cols) and spreads it to regional sheets (16 in all). This process (on my machine usually takes about 4-6 minutes. Then I added another 91 columns with historical data and now the same calculation takes approximately 1 hour and 15 minutes. What a difference? Can anyone explain why? If I were to put this historical data in another worksheet, how can I tie the two sheet together? Any help will be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| slow processing with .find | Excel Programming | |||
| speed of processing | Excel Programming | |||
| slow Macro speed | Excel Programming | |||
| how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit | Excel Worksheet Functions | |||
| Free Tool (Add-in) To Speed Up Your Data Processing | Excel Worksheet Functions | |||
Threaded Mode
