Ok, I'm not with you yet but I'm making progress. I'll describe what I understand so far and you correct me:
In the History worksheet is a column that pulls data from another worksheet named Current Status. The formula for pulling that data is simple:
Code:
='Current Status'!$E$2
='Current Status'!$F$2
='Current Status'!$E$3
='Current Status'!$F$3
='Current Status'!$E$4
='Current Status'!$F$4
='Current Status'!$E$5
='Current Status'!$F$5
...and so on.
But elsewhere on the History worksheet is a table that is populated from an Oracle query. Every time the workbook is opened the Oracle query is refreshed, which is as it should be — but when that happens,
this column is changed, too, which shouldn't happen; every value is changed to "='Current Status'!$G$2". Your question is why the Oracle query is refreshing not just the proper range in the History worksheet, but also this column (and why just in that way). Right so far?
Actually, I'm pretty sure I'm wrong. Maybe the part that's getting updated
is in the Oracle query's range. Or maybe not every formula in this column is being changed back to $G$2. Tell me what I have wrong and maybe we'll be ready to proceed from there.