Prev: Two formulas in on cell based on two numbers in another cell?
Next: Creating "Billboard" Like Charts
From: Fred Smith on 19 Mar 2010 18:41
Sounds like a problem with your laptop, not Excel. If you're sure you have
exactly the same data on each computer, I would reinstall Excel.

My bet, however, is that your data isn't exactly what you think it is.

Regards,
Fred

"lisay" <lisay(a)discussions.microsoft.com> wrote in message
news:B33C8F0D-4140-4BBC-99DD-D9707F21228D(a)microsoft.com...
> BTW, another note, the other laptop that I got this to work also has Excel
> 2003. It does not make sense to me why this would be a problem on one
> laptop
> and not working on another laptop with both having the same version of
> Excel.
>
> "lisay" wrote:
>
>> 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

From: lisay on 20 Mar 2010 04:53
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" <lisay(a)discussions.microsoft.com> wrote in message
> news:C7703EF0-B36E-4FC9-A225-359939CC2F5E(a)microsoft.com...
> > 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
>
> .
>
From: lisay on 23 Mar 2010 04:17
The re-install of Excel 2003 fixed the problem. Not sure what happened.
Thanks!

"lisay" wrote:

> 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" <lisay(a)discussions.microsoft.com> wrote in message
> > news:C7703EF0-B36E-4FC9-A225-359939CC2F5E(a)microsoft.com...
> > > 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
> >
> > .
> >
First  |  Prev  | 
Pages: 1 2
Prev: Two formulas in on cell based on two numbers in another cell?
Next: Creating "Billboard" Like Charts