DEAR ALL

Excel 97:
1. file size 2.5mb bcos of lots of tanks quantities.
2. Has links to another worksheet on network file.
3. Deletes some sheets in another worksheet and replaces with todays sheets.

Need to know:
a) While so, in item-3, when the network file is opened, it says the file
opened has links and asks if the links need to be updated. On clicking
'yes', thats it--"programme error' and on clicking on it the excel shuts
down.

b) When one sheet which has links is pasted in network using VB, the
unfilled rows show #ref. How to get over with this #ref in pasted cell into
network sheet.

Pls help me and I will be watching whole day for it.

brgds/captgnvr