Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trouble repeating cells in table
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!!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trouble repeating cells in table
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 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!!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trouble repeating cells in table
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" wrote in message ... 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!!!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trouble repeating cells in table
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" wrote in message ... 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!!!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trouble repeating cells in table
You are welcome
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "William McNeill" wrote in message ... 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" wrote in message ... 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!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
two-way variable table keeps repeating same value | Excel Worksheet Functions | |||
how do I shred repeating fields in an excel table? | New Users to Excel | |||
Repeating rows in pivot table - how to | Excel Discussion (Misc queries) | |||
Repeating Row Fields in a pivot table | Excel Worksheet Functions | |||
Repeating data in a Pivot table | Excel Worksheet Functions |