MSQuery and formula in adjacent cells

D

D.S.

I have some columns to the left of some Query data. When the query is
refreshed, It is not copying the formula down in the adjacent columns. I
have went into the "External Data Range Properties" and check the box to
"fill down formula in adjacent cells", but it still doesn't seem to work.
Is it because the columns are to the left of the query?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Copy addition formula of non-consecutive horizontal cells 2
Fill column adjacent to external query (Excel 2007) 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Doesn't "immediately adjacent" mean right before and or after? 0
Import data, fill adjacent formulas 1
Filling adjacent formulas with data import 1
Drop down list control value in vba 2

Top