My applogies for not being as clear as I could have been. There are Two sheets in hte workbook



1)Current Status
2)History

The Current status sheet is a table of numbers that gets edited by hand with a set of numbers.

The History sheet is rather unqiue. It is a table where some of the data is pulled from an Oracle query. Some of the data is pulled in directly as it is entered on the "Current Status" sheet. Then there are some columns that are some simple arithmatic.


1) You say the cell reference changes "accordingly"? What causes it to change? I'm guessing it's when you add, to Current-Status worksheet, rows above 2 or columns to the left of G; is that what you meant?

Here I mean that there are 2 columns on the Current Status Sheet I am pulling data from (Column E and F). These then put into one Column on the History sheet. So I should see in column B on the history sheet
='Current Status'!$E$2
='Current Status'!$F$2
='Current Status'!$E$3
='Current Status'!$F$3

and so on

2) What, exactly, is refreshed? A range, a worksheet, the whole workbook?


When the workbook is opened the Oracle query on the history sheet is automatically refreshed to pull in the current data.

3) How is it refreshed? By closing and opening the workbook? By hitting <F9>? What?

It is an automatic refresh

4) Which formula changes? The one in Sheet1!A1, I suppose? Or something else?

The formula on the "history" sheet changes

5) What does it change from? If it's Sheet1!A1, I suppose it changes from ='Current Status'!$G$2?

='Current Status'!$G$2 is that it changes to. The correct formula is written above.

6) What does it change to?

See above


7) Whatever it changes to, why do you refer to that as "the original formula"?

Not sure on that one



Hope that helps.

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:...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.