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.