Special Paste Question

[Cooky]

I have used the special paste function to take cell information from a file server in another city(it works across a WAN). What I need to do, is change the method of update from 'automatic' to 'manual'. Using Edit, Links..., I have opened a dialog box, but the 'manual update' button is greyed out.

I have also tried un-checking the 'update remote references' box in Tools, Options.... But it didn't work.

Can anyone suggest how I can change the link to a manual update???

Many Thanks