I think maybe I gave up too soon. It's true that I don't know how queries interact with Excel tables, but the basic description leaves me puzzled. The way I'm picturing this ...

Look, let me make up some specifics. Your Oracle query is intended to update information within a certain range, right? So for the purpose of this question let's say that range is History!H2:K199; that is, when you refresh the Oracle query, it updates the contents of History!H2:K199.

Now your complaint, as I understand it, is that one of the columns in that range—let's say J2:J199—keeps changing. You set it to refer to the Current Status worksheet, as described below, but whenever the query is refreshed the formulae in that range change back to something else.

Here's my question: Since you say that J2:J199 is part of the table that the Oracle query updates, why are you surprised and upset that Oracle updates it? If you wanted the query to update that column, why is it a problem that it's doing so? And (here's the real question, I suspect), if you don't want the query to update that column, why is that column located within the table that the query updates? It seems to me that if you want this data to remain unchanged, then you must locate it somewhere outside the table that is being refreshed.