trouble repeating cells in table

William McNeill · External Since: Nov 03, 2009 Posts: 2

I have a spreadsheet which imports data from Access. The Access data changes
weekly, and I then go into the spreadsheet and refresh the tables. In the
tables, I could at one time type in a new formula in a new column and it
would automatically repeat this formula down the entire column the whole
length of the table. Somehow I must have turned this function off, and I can
not figure how to turn it back on. Excel 2007. Please help, thanks!!!!

Gord Dibben · External Since: Feb 23, 2004 Posts: 9178

Typing a formula in a new column and having the formula automatically
repeated down the column has never been a built-in feature of any version of
Excel.

There is no setting turned off that can be turned back on.

Perhaps you had some event code that did the automatic fill down?

If the new column is adjacent to a filled column, double-click on the fill
handle of cell you just entered the formula into.

Gord Dibben MS Excel MVP

On Tue, 3 Nov 2009 06:21:02 -0800, William McNeill
<WilliamMcNeill.DeleteThis@discussions.microsoft.com> wrote:

>I have a spreadsheet which imports data from Access. The Access data changes
>weekly, and I then go into the spreadsheet and refresh the tables. In the
>tables, I could at one time type in a new formula in a new column and it
>would automatically repeat this formula down the entire column the whole
>length of the table. Somehow I must have turned this function off, and I can
>not figure how to turn it back on. Excel 2007. Please help, thanks!!!!

Ashish Mathur · External Since: May 21, 2005 Posts: 238

Hi,

This happens because the range of data imported from Access is a Table
(Ctrl+L). One of the features of a Table is that it auto expands. If you
turn the table feature off, the auto expansion would not work and therefore
the formulas would not get copied down. However, if you remove the list,
the link to Access would be lost.

Insert the formula one column after the last column and now the auto fill
formula will not work. Now you may compress the width of the blank column.
Please note that existance of blank rows/columns in your range has its own
problems but you immediate problem will be solved.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"William McNeill" <WilliamMcNeill.TakeThisOut@discussions.microsoft.com> wrote in
message news:DBD784FE-EB89-45C3-AF0C-5B62E929514D@microsoft.com...
> I have a spreadsheet which imports data from Access. The Access data
> changes
> weekly, and I then go into the spreadsheet and refresh the tables. In the
> tables, I could at one time type in a new formula in a new column and it
> would automatically repeat this formula down the entire column the whole
> length of the table. Somehow I must have turned this function off, and I
> can
> not figure how to turn it back on. Excel 2007. Please help, thanks!!!!

William McNeill · External Since: Nov 03, 2009 Posts: 2

Thank you very much!!!

"Ashish Mathur" wrote:

> Hi,
>
> This happens because the range of data imported from Access is a Table
> (Ctrl+L). One of the features of a Table is that it auto expands. If you
> turn the table feature off, the auto expansion would not work and therefore
> the formulas would not get copied down. However, if you remove the list,
> the link to Access would be lost.
>
> Insert the formula one column after the last column and now the auto fill
> formula will not work. Now you may compress the width of the blank column.
> Please note that existance of blank rows/columns in your range has its own
> problems but you immediate problem will be solved.
>
> --
> Regards,
>
> Ashish Mathur
> Microsoft Excel MVP
> www.ashishmathur.com
>
> "William McNeill" <WilliamMcNeill RemoveThis @discussions.microsoft.com> wrote in
> message news:DBD784FE-EB89-45C3-AF0C-5B62E929514D@microsoft.com...
> > I have a spreadsheet which imports data from Access. The Access data
> > changes
> > weekly, and I then go into the spreadsheet and refresh the tables. In the
> > tables, I could at one time type in a new formula in a new column and it
> > would automatically repeat this formula down the entire column the whole
> > length of the table. Somehow I must have turned this function off, and I
> > can
> > not figure how to turn it back on. Excel 2007. Please help, thanks!!!!
>

Ashish Mathur · External Since: May 21, 2005 Posts: 238

You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"William McNeill" <WilliamMcNeill.DeleteThis@discussions.microsoft.com> wrote in
message news:EAC6D62B-CBC3-4530-AFF0-D95FACC22407@microsoft.com...
> Thank you very much!!!
>
> "Ashish Mathur" wrote:
>
>> Hi,
>>
>> This happens because the range of data imported from Access is a Table
>> (Ctrl+L). One of the features of a Table is that it auto expands. If
>> you
>> turn the table feature off, the auto expansion would not work and
>> therefore
>> the formulas would not get copied down. However, if you remove the list,
>> the link to Access would be lost.
>>
>> Insert the formula one column after the last column and now the auto fill
>> formula will not work. Now you may compress the width of the blank
>> column.
>> Please note that existance of blank rows/columns in your range has its
>> own
>> problems but you immediate problem will be solved.
>>
>> --
>> Regards,
>>
>> Ashish Mathur
>> Microsoft Excel MVP
>> www.ashishmathur.com
>>
>> "William McNeill" <WilliamMcNeill.DeleteThis@discussions.microsoft.com> wrote in
>> message news:DBD784FE-EB89-45C3-AF0C-5B62E929514D@microsoft.com...
>> > I have a spreadsheet which imports data from Access. The Access data
>> > changes
>> > weekly, and I then go into the spreadsheet and refresh the tables. In
>> > the
>> > tables, I could at one time type in a new formula in a new column and
>> > it
>> > would automatically repeat this formula down the entire column the
>> > whole
>> > length of the table. Somehow I must have turned this function off, and
>> > I
>> > can
>> > not figure how to turn it back on. Excel 2007. Please help,
>> > thanks!!!!
>>