Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill down not working in Excel 2007
Hi All,
I have a worksheet with a data table (from an ODBC source) which I want to calculate values based on the ODBC query results, the problem is the fill down stops at row 48 everytime regardless if there are more than 48 rows if there are less the last filed shows a calucaltion error its really frustrating. In XP & 2003 there used to be a flag on the data properties to "Fill down formulas in adjacent cells" which I can't find in 2007. why is the fill down simply stopping next to an ODBC refreshed table. Also in Excel 2003 (& previous version's) when pulling data into a worksheet you had the option to not display the original field name that existed in the ODBC you could simply populate the field with the required value, how do you do this now - my ODBC's are forcing me to use the column headers from the original data source & I don't want that. Love Excel 2007 but these two simple functions seem to have vanished -Microsoft giveth Microsoft taketh away! :-( Any pointers would be great. Tia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
F2 Key not working in Excel 2007 | Excel Discussion (Misc queries) | |||
Fill Handle in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
fill color not working in excel 2007 | Excel Worksheet Functions | |||
In Excel fill & font colors not working | Excel Worksheet Functions |