Hi All;

I have a worksheet that queries an external database and I have formulas that tie into that query - ex. the query brings back dates to column B:B, I want the week number in A:A so I type in IF(B2="","",WEEKNUM(B2,2)).

What's happening is when I refresh the query the formulas are getting messed up - if cell A1 called out to B1 before the query its calling out to B47 after I refresh. Sometimes I get #REF errors. Is there a way I can have A1 always call out to B1, and all the way down? The query pulls close to 5000 values each time it refreshes, so I'm hoping I dont have to put $ signs on each cell in column A or if that would even solve the problem.

Any help is greatly appriciated, thanks