I'm not sure I follow. I gather you have a workbook with at least two sheets; one I'll call Sheet1 and the other 'Current Status'. Somewhere on Sheet1, let's say in A1, you have this formula:
Code:
='Current Status'!$G$2
It correctly displays the value from G2 in the Current Status sheet. But when something ("the table") is refreshed, a formula changes. Some specific questions:
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?
2) What, exactly, is refreshed? A range, a worksheet, the whole workbook?
3) How is it refreshed? By closing and opening the workbook? By hitting <F9>? What?
4) Which formula changes? The one in Sheet1!A1, I suppose? Or something else?
5) What does it change from? If it's Sheet1!A1, I suppose it changes from ='Current Status'!$G$2?
6) What does it change to?
7) Whatever it changes to, why do you refer to that as "the original formula"?