Ok, so here is my problem.

I have a database linked to worksheet in a workbook. We will call it sheet 1. I have a reference to several of the cells from sheet 1 on sheet 2. When I refresh the data on sheet 1, which comes from a DB that has had records removed from it as well as columns added. The references on sheet 2 perform a weird action.

For the purpose of this example, here is the data:

fldName fldEmpID

are my columns in sheet 1.

In sheet 2, I have made reference to these cells. I have used the following:
=CELL("contents",Sheet1!E2) =Sheet1!G2
=CELL("contents",Sheet1!E3) =Sheet1!G3
=CELL("contents",Sheet1!$E$4) =Sheet1!G4
=CELL("contents",Sheet1!E5) =Sheet1!G5
=CELL("contents",Sheet1!E6) =Sheet1!G6
=CELL("contents",Sheet1!E7) =Sheet1!G7
=CELL("contents",Sheet1!E8) =Sheet1!G8


I have intentionally used two types of references, both with and without absolute references for testing purposes.

Problem: When updating the data, the reference to E4 and G4 are both deleted and it continues to number with E5 and G5.
Here are the updated fields after the database update:
=CELL("contents",Sheet1!E2) =Sheet1!G2
=CELL("contents",Sheet1!E3) =Sheet1!G3
=CELL("contents",Sheet1!$E$5) =Sheet1!G5
=CELL("contents",Sheet1!E6) =Sheet1!G6
=CELL("contents",Sheet1!E7) =Sheet1!G7
=CELL("contents",Sheet1!E8) =Sheet1!G8

Note that both references to 4 was deleted.

Steps to reproduce:
1. Open Excel spreadsheet.
2. Goto Sheet1 and click in the data.
3. Pull down menu under "Refresh All" and choose "Refresh".
4. Wait for data to refresh.
5. Goto sheet 2 and notice that the fields have changed.

I can replicate at will. Any suggestions on what is happening.

Regards,

Allen