Adjacent Column Formula Fill Down not available on All connection

[haggecha]

These is not the option of filling down Adjacent columns with formulas
options for all type of connections, I created a connection to another excel
file on a Sharepoint server using hte ODC->Excel file connection setup, when
I use the coneection to import the table data, I do not have the option to
fill down formula like I do wtih webqueries, is this a bug or is there
another way to do this?

 

[Shane Devenshire]

Hi,

What version of Excel are you using? How did you create the connection?
You say you are using ODC do you mean ODBC. Did you do this via MS Query?
Please supply more detail?

 

[haggecha]

Hi Shane,

Excel 2007,

I have a an excel file in Sharepoint and created a connection using

ODBC DSN -> Excel Files. entered our sharepoint site as
\\sharepoint\sites\..... and then selected the excel file that contains the
data table defined as a range.

Clicking on existing coneections, I can chose to have the data come in as a
table or pivot table, and I select table. this is where I want to add
formulas.

Chad