I used the same data file on both laptop and one works while the other does
not. So, I know it is not a data problem. Because the data has confidential
info, I will have to dummy out the data first. What I might try first is
re-install Excel and see what happens.

Thank you both, for your suggestions. Will let you know once Excel is
reinstalled.

"Bernard Liengme" wrote:

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

.