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.

Formula calculating very slow
 

Alex,

Presumably the formula are already in column P and calculation is set to
automatic so calculation will begin as soon as a line of data are populated
so this 'may' help

Application.screenupdating=false

your code

Application.screenupdating=true

Mike

"Alex" wrote:

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.

Formula calculating very slow
 

Thanks Mike. I already have screenupdating turned off/on. It still slow.

"Mike H" wrote:

Alex,

Presumably the formula are already in column P and calculation is set to
automatic so calculation will begin as soon as a line of data are populated
so this 'may' help

Application.screenupdating=false

your code

Application.screenupdating=true

Mike

"Alex" wrote:

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.

Formula calculating very slow
 

Calculation set to Manual too?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Alex" wrote in message ...
| Thanks Mike. I already have screenupdating turned off/on. It still slow.
|
| "Mike H" wrote:
|
| Alex,
|
| Presumably the formula are already in column P and calculation is set to
| automatic so calculation will begin as soon as a line of data are populated
| so this 'may' help
|
| Application.screenupdating=false
|
| your code
|
| Application.screenupdating=true
|
| Mike
|
| "Alex" wrote:
|
| 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.

Formula calculating very slow
 

No, it was set to automatic. I've got it working now. Thanks so much.

"Niek Otten" wrote:

Calculation set to Manual too?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Alex" wrote in message ...
| Thanks Mike. I already have screenupdating turned off/on. It still slow.
|
| "Mike H" wrote:
|
| Alex,
|
| Presumably the formula are already in column P and calculation is set to
| automatic so calculation will begin as soon as a line of data are populated
| so this 'may' help
|
| Application.screenupdating=false
|
| your code
|
| Application.screenupdating=true
|
| Mike
|
| "Alex" wrote:
|
| 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.