View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ion ion is offline
external usenet poster
 
Posts: 12
Default 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