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?

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?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"haggecha" wrote:

> 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?

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


"Shane Devenshire" wrote:

> 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?
>
> --
> If this helps, please click the Yes button.
>
> Cheers,
> Shane Devenshire
>
>
> "haggecha" wrote:
>
> > 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?