Query linked cell values
 

Worksheet1 "Answer" column has cells with radio buttons linked to cells in
"value" column (e.g C2 contains radio buttons linked to E2, C3 contains radio
buttons linked to E3,...). Cells are not locked nor hidden. Buttons/linked
cells work fine locally, but when I use a query (via import data wizard) to
populate Wksheet2, entries in the "value" column are empty (other fields work
as expected). Unfortunately I'm saddled with Excel 2k, not the latest
(employer's choice).