| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula calculating very slow
I have the following formula in 5000 cells in column P in my worksheet.
=IF($O2<"",NETWORKDAYS(O2,N2),"") Using a module, I'm importing the rows that contain data in columns A:O. After the rows have been imported into the worksheet I can see the above formula calculating. The problem is that it is extremely show, approximately 2 seconds per row. Is there a way I can speed this up? Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| worksheet calculating SLOW | Excel Discussion (Misc queries) | |||
| Very Slow Calculating | Excel Discussion (Misc queries) | |||
| Slow Calculating and optimizing | Excel Programming | |||
| Calculating is very slow | Excel Discussion (Misc queries) | |||
| Microsoft request for slow-calculating workbooks | Excel Discussion (Misc queries) | |||
Threaded Mode
