Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Lookup Lookup | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
lookup problems | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |