Dear All

WorksheetA; sheet1 has links to sheet2;

sheet1 is copied to another new workbook by vb using cells select, selction
copy and activesheetpaste and saved as sheet1_copy.

The problem is that the data changes in sheet1_copy when worksheetA-sheet2
data is changed.

Can u pls tell me how to get over this.

brgds/captgnvr