Very odd. Want to send me a sample file? Get my email from my website
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"lisay" wrote in message
...
Does anyone know if there is a setting in Excel 2003 where we set number
of
rows a formula should pick up? I have a sumif formula to calculate range
from row 2 to 20,000. However, it only calculates the first 1000. Then,
I
have to change the range to 1001 to 2000 for the next set. This only
happens
on a particular laptop.

Thanks,
Lisa