On Mar 24, 2:46*pm, SMH wrote:
There are two tabs within one workbook. *Sheet A has multiple formulas
reading data from Sheet B; Sheet B is an imported text file that can have a
range of results. *I.E. Populated up to row 5 or row 60. *I have created a
connection to that text file that allows me to "refresh" the results at any
time.

Once refreshed, the some of the formulas I created in Sheet A are then
altered. *Why is this happening? *My thoughts: when I "set up" the formula's,
my example data is only including data up to row 30, however, when I refresh
with real data, the data can alter to either be 60 rows or 5 rows, so the
formulas are jumping.

Is there any way to "hard code" the formulas so that no matter what changes
to the data, they will not change? *Any assistance is greatly appreciated.

Example:
Sheet A formulas:
A2= Data!H3
A3= Data!H15
A4= Data!H27
A5= Data!H39

Once I "Refresh" the data in Sheet B, Sheet A's formulas say:
A2= Data!H3
A3= Data!H15
A4= Data!H27
A5= Data!H64

Try entering them as follows
A2= Data!$H$3
A3= Data!$H$15
A4= Data!$H$27
A5= Data!$H$64
the $'s should lock them in.