So... am I correct in thinking you're not pushing your updates into excel from RSLINX, but actually

*pulling* the data into excel from the other application by way of your formula? (That's the way it looks to me. - and it's the way I do it from a gehcs app.)

If I'm right, then you should be using a Worksheet_Calculation event instead of the Worksheet_Change. This gets a little bit more involved.

You'll want some way upon opening the workbook to record the initial output bit somewhere in the sheet to be used as a static value. Then with each calculation performed in the sheet, you'll want to compare the current output bit to that static value. If it's not equal to it, then record B2's value (the new output bit value) in the next cell to the right, and then copy the new output bit to the static value cell so that's what gets compared against the next time. (Sounds kind confusing I guess...)

Give this a try in a blank workbook first and I think you'll see what I mean.

In B2 I simply put the formula =A1+A2

I am going to use A3 as the "static value" cell.

In the worksheet module (replacing the worksheet change code you have in there now) I used this:

Code:

```
Private Sub Worksheet_Calculate()
If [B2] <> [A3] Then
[IV2].End(xlToLeft)(1, 2).Value = [B2].Value
[A3].Value = [B2].Value
End If
End Sub
```

Play with the values in A1 or A2 and I think you'll get the idea of what I'm thinking.

Now, if this is what you want, you can get your initial "static value" when the workbook opens by using something like this in the ThisWorkbook module.

Code:

```
Private Sub Workbook_Open()
Sheets("Sheet1").[A3].Value = Sheets("Sheet1").[B2].Value
End Sub
```

Does this help any?

Dan