YET Another Excel Query

[boycee]

I am importing data using Excel web query. It works fine but I have formulas associated with the data that is imported. When additional data is imported on refresh it adds to the original data, but in doing so it shunts the cells containing the formulas, out of positon and creates incorrect cell references. I have the formulas on the same sheet as the imported data. How can I stop this from happening?

[GeorgeUK]

Depends on what you are importing (always the same layout?) and how the data is arranged - is the incoming data overwriting existing data or going infront?

You might want to try an absolute reference.
Instead of A1 put $A$1

if this was copied down - A1 would then look at A2 etc but $ signifies "only" - so you are saying only column A and only row 1.

Is this what you mean?
If not, might need an example so we can see what's happening

[boycee]

thanx geo that seems to have cracked it mate

[Ian]

I get around this by importing the data starting at, say, e1. Columns a to d can then be used for formulas and they won't get corrupted if extra columns appear.