Updating column formula after a refresh

[Keith]

Can anybody point me in the right direction.

I have several Excel files that are linked through ODBC
to our main systems databases.

Every week the user has to refresh the data. But after
that they also need to replicate a formula in several
different column's down to the new liast row.

Is there any way to automate this?

Also some sheets are the data sheets for pivot tables.
Can the pivot table be automated to include the extra
data the refresh created?

 

[Frank Kabel]

Hi Keith
for the first question you could chnage your formula to
=IF(A1<>"",your_formula,"")
and copy this down for more rows than currently needed. If you want to
automtae this you have to run a macro.

For the second question you may have a look at
http://www.contextures.com/xlPivot01.html