Specifying adjacent formulae for a QueryTable AutoRefresh's FillAdjacentFormulas
 

So, I have this query table. And next to its result range, I have a
number of derived column. The first one is the time difference from
the initial record[like =(C43-C$3)], and the rest are rates of the
form =(F43-F42)/($C43-$C42), where I see how quickly one value changed
to another.
The time column updates great. But, the refreshes ignore the other
columns. Does only the first adjacent column ever get filled? Is there
something I can do to get the other columns filled in?
Thanks!
Ion

Specifying adjacent formulae for a QueryTable AutoRefresh's FillAdjacentFormulas
 

Sorry, that's not exactly right. The three rate columns are not only
not appended to, but the last record is changed. I add four records a
minute to the source table, and I refresh every minute, so I expect
four new rows. So, say I have columns A, B, C, D and E populated by
the query and manually updated row 43 to have =(A43-A$2), =(C43-C42)/
($F43-$F42), =(D43-D42)/($F43-$F42), =(E43-E42)/($F43-$F42) in columns
F, G, H and I where 43 is the last row. So, now, when four records are
added, we see =(A47-A$2) in column F of for 47, but G, H and I are
blank. F, G, H and I of row 43, however, now read
=(A43-A$2), =(C47-C42)/($F47-$F42), =(D47-D42)/($F47-$F42), =(E47-
E42)/($F47-$F42)
which is not what I wanted -- rows 42 and lower are not affected.
Ion

On Mar 12, 3:07 pm, "ion" wrote:
So, I have this query table. And next to its result range, I have a
number of derived column. The first one is the time difference from
the initial record[like =(C43-C$3)], and the rest are rates of the
form =(F43-F42)/($C43-$C42), where I see how quickly one value changed
to another.
The time column updates great. But, the refreshes ignore the other
columns. Does only the first adjacent column ever get filled? Is there
something I can do to get the other columns filled in?
Thanks!
Ion