Lookup problems
 

I have 2 sheets in a workbook. The one sheet has a ODBC query in it and the
range of data can grow and shrink based on the data query. The second sheet
has formulas looking to the first sheet for formating reasons. If I refresh
sheet 1 with the ODBC query on it and the sheet grows (more records) the
formulas in sheet 2 change. (ie cell A100 was "='JC INFO'!F1369" but after
refresh changes to "='JC INFO'!F1400"). I do not want the formulas to change
in the second sheet - how can I do this?

Hi
I have had this problem with financial spreadsheets. Once the ODBC data is
refreshed, the results are no longer reliable (I found out to my cost). I
just got into the habit of re-Autofilling the range each time I refreshed,
to ensure that the formulas related to the correct rows. I very rarely use
Excel for this type of job now - it's too unreliable. I've ported most of
this type of job into Access.

--
Andy.


"thecuzin" wrote in message
...
I have 2 sheets in a workbook. The one sheet has a ODBC query in it and the
range of data can grow and shrink based on the data query. The second
sheet
has formulas looking to the first sheet for formating reasons. If I
refresh
sheet 1 with the ODBC query on it and the sheet grows (more records) the
formulas in sheet 2 change. (ie cell A100 was "='JC INFO'!F1369" but after
refresh changes to "='JC INFO'!F1400"). I do not want the formulas to
change
in the second sheet - how can I do this?