text and numbers
 

I have a text and number string that I use to link my excel worksheet to a
PLC for extracting values. The string is: =RSLinx|demo2!'gauge_offset_y[0]',
where 0 is the variable. There are potentially 1000 variables that I need to
use;
(ex. =RSLinx|demo2!'gauge_offset_y[1000]'), as well as other text strings.
I used ="=RSLinx|demo2!'gauge_offset_y["&A1&"]'" to copy this down, and then
copy/pasted special, values only to get the correct result, but even though
the cell reads exactly what I want, it does not read the tag in the PLC. If I
then double click in each cell and hit enter, it doesn't seem to change the
cell contents, but then it works!!??.
I would like to not have to double click in each cell to make this work.

Any advice?