Can I automatically extend formulas to added lines in Excel 2002?

[BillyV]

When I add new lines to expand a worksheet, existing formulas do not extend
to the new lines. I have the Tools/Options/Edit 'Extend List Formats &
Formulas' box checked. Should this happen automatically?

[Jim Rech]

>Should this happen automatically?

Yes it should. But it doesn't happen when you insert the row, but rather it
happens after you enter the data in the new row.

--
Jim
"BillyV" <BillyV@discussions.microsoft.com> wrote in message
news:47794C6C-0C24-4866-A8D8-B930CE35BE76@microsoft.com...
> When I add new lines to expand a worksheet, existing formulas do not
> extend
> to the new lines. I have the Tools/Options/Edit 'Extend List Formats &
> Formulas' box checked. Should this happen automatically?

[BillyV]

Thanks very much. I've actually had that happen in the past after I entered
data, and didn't know why. But I am working on a new spreadsheet, and
nothing I try seems to extend the formulas, even entering data - I'm still
stumped.

Bill


"Jim Rech" wrote:

> >Should this happen automatically?
>
> Yes it should. But it doesn't happen when you insert the row, but rather it
> happens after you enter the data in the new row.
>
> --
> Jim
> "BillyV" <BillyV@discussions.microsoft.com> wrote in message
> news:47794C6C-0C24-4866-A8D8-B930CE35BE76@microsoft.com...
> > When I add new lines to expand a worksheet, existing formulas do not
> > extend
> > to the new lines. I have the Tools/Options/Edit 'Extend List Formats &
> > Formulas' box checked. Should this happen automatically?
>
>
>

[Jim Rech]

>>I'm still stumped.

Me too. I guess I'd have to see the worksheet or a snippet of it that has
the problem. MS did document how auto extend works if you want to sleuth
further:

http://support.microsoft.com/kb/231002/

--
Jim
"BillyV" <BillyV@discussions.microsoft.com> wrote in message
news:7172AC23-C1F7-4E8C-8D0C-0E47353988C3@microsoft.com...
| Thanks very much. I've actually had that happen in the past after I
entered
| data, and didn't know why. But I am working on a new spreadsheet, and
| nothing I try seems to extend the formulas, even entering data - I'm still
| stumped.
|
| Bill
|
|
| "Jim Rech" wrote:
|
| > >Should this happen automatically?
| >
| > Yes it should. But it doesn't happen when you insert the row, but
rather it
| > happens after you enter the data in the new row.
| >
| > --
| > Jim
| > "BillyV" <BillyV@discussions.microsoft.com> wrote in message
| > news:47794C6C-0C24-4866-A8D8-B930CE35BE76@microsoft.com...
| > > When I add new lines to expand a worksheet, existing formulas do not
| > > extend
| > > to the new lines. I have the Tools/Options/Edit 'Extend List Formats
&
| > > Formulas' box checked. Should this happen automatically?
| >
| >
| >

[BillyV]

Thanks again - I'll give that a try.



"Jim Rech" wrote:

> >>I'm still stumped.
>
> Me too. I guess I'd have to see the worksheet or a snippet of it that has
> the problem. MS did document how auto extend works if you want to sleuth
> further:
>
> http://support.microsoft.com/kb/231002/
>
> --
> Jim
> "BillyV" <BillyV@discussions.microsoft.com> wrote in message
> news:7172AC23-C1F7-4E8C-8D0C-0E47353988C3@microsoft.com...
> | Thanks very much. I've actually had that happen in the past after I
> entered
> | data, and didn't know why. But I am working on a new spreadsheet, and
> | nothing I try seems to extend the formulas, even entering data - I'm still
> | stumped.
> |
> | Bill
> |
> |
> | "Jim Rech" wrote:
> |
> | > >Should this happen automatically?
> | >
> | > Yes it should. But it doesn't happen when you insert the row, but
> rather it
> | > happens after you enter the data in the new row.
> | >
> | > --
> | > Jim
> | > "BillyV" <BillyV@discussions.microsoft.com> wrote in message
> | > news:47794C6C-0C24-4866-A8D8-B930CE35BE76@microsoft.com...
> | > > When I add new lines to expand a worksheet, existing formulas do not
> | > > extend
> | > > to the new lines. I have the Tools/Options/Edit 'Extend List Formats
> &
> | > > Formulas' box checked. Should this happen automatically?
> | >
> | >
> | >
>
>
>

[BillyV]

That support side helped a lot - thanks for the tip. I found a couple of
other things there too. My worksheet is still erratic - works sometimes, and
not other times. The support site suggests it could have to do with the way
the above cells are formatted, which I don't want to change. But at least I
(probably) know why.

Thanks again.
Bill

"Jim Rech" wrote:

> >>I'm still stumped.
>
> Me too. I guess I'd have to see the worksheet or a snippet of it that has
> the problem. MS did document how auto extend works if you want to sleuth
> further:
>
> http://support.microsoft.com/kb/231002/
>
> --
> Jim
> "BillyV" <BillyV@discussions.microsoft.com> wrote in message
> news:7172AC23-C1F7-4E8C-8D0C-0E47353988C3@microsoft.com...
> | Thanks very much. I've actually had that happen in the past after I
> entered
> | data, and didn't know why. But I am working on a new spreadsheet, and
> | nothing I try seems to extend the formulas, even entering data - I'm still
> | stumped.
> |
> | Bill
> |
> |
> | "Jim Rech" wrote:
> |
> | > >Should this happen automatically?
> | >
> | > Yes it should. But it doesn't happen when you insert the row, but
> rather it
> | > happens after you enter the data in the new row.
> | >
> | > --
> | > Jim
> | > "BillyV" <BillyV@discussions.microsoft.com> wrote in message
> | > news:47794C6C-0C24-4866-A8D8-B930CE35BE76@microsoft.com...
> | > > When I add new lines to expand a worksheet, existing formulas do not
> | > > extend
> | > > to the new lines. I have the Tools/Options/Edit 'Extend List Formats
> &
> | > > Formulas' box checked. Should this happen automatically?
> | >
> | >
> | >
>
>
>