Why does my formula change?

[JohnBOA]

I am using MS Query to get external data and return it to cells A94 through B100(column A is the return name column B is the return value)
My formula in cell A1 starts off like this:
=
IF(A94="Rutkowski",B94,
IF(A95="Rutkowski",B95,
IF(A96="Rutkowski",B96,
IF(A97="Rutkowski",B97,
IF(A98="Rutkowski",B98,
IF(A99="Rutkowski",B99,
IF(A100="Rutkowski",B100,"0&quot)))))))
BUT after a couple of opens it looks like this:
=
IF(A94="Rutkowski",B94,
IF(A95="Rutkowski",B95,
IF(A96="Rutkowski",B96,
IF(A97="Rutkowski",B97,
IF(A98="Rutkowski",B98,
IF(#REF!="Rutkowski",#REF!,
IF(A99="Rutkowski",B99,
IF(A100="Rutkowski",B100,"0&quot)))))))
The result in the spreadsheet cell A1 has a value of #REF! and my users are wondering what is this value.

Any help would be greatly appreciated!!

Thank you.

 

[xlbo]

#REF! is the reference error and usually means you are tryinmg to reference something that is not there.
What do you mean by a couple of opens ?? Rgds
~Geoff~

 

[JohnBOA]

By opens I mean start Excel and open the same spreadsheet the next day. I use the same spreadsheet everyday. After a couple of days the #REF! shows up. This area that I am referencing is the area where MS Query returns its results.

 

[acron]

Does your query update on each update, and if so is it possible that is imserting an additional row of data ?

A.C.

 

[acron]

Sorry meant to say update on each file open !

A.C.

 

[JohnBOA]

Yes. On each update I automatically run the query and update the area. The query can return 2-9 rows.

John