Formula calculating very slow

[Alex]

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.

 

[Mike H]

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]

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

 

[Niek Otten]

Calculation set to Manual too?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.

 

[Alex]

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