Formulas Changing
 

MS OS: 2000, Excel: 2000

Sheet 2 has data on it supplied by a MS Query.
Sheet1 is looking at each cell in Sheet2 and displays the exact same data.
Example Cell a2 on Sheet1 is:

=IF('Report Capacity Violations'!$A$2="","",VALUE(CONCATENATE(MID('Repo rt
Capacity Violations'!$A$2,5,2),"/",RIGHT('Report Capacity
Violations'!$A$2,2),"/",LEFT('Report Capacity Violations'!$A$2,4))))

I do it this way so that I can properly format the data and use the formulas
I have on Sheet1 with the data on Sheet2. Sheet2 is Report Capacity
Violations in the above formula.

The problem is for some reasons the formulas change and try to reference the
incorrect cells. In the above formula the sheet never changes but the cells
change. I even changed its referencing to absolute using $A$2 instead of A2.

I go down 30 rows with the formulas. Sometimes rows 1 through 5 are OK then
the next value is $A$12 and so on.

Please help.

Thanks in advanced.

--
Richard