Automatic Links

[hemsleysut]

I copied and paste special from workbook A to workbook B. I then deleted workbook A. Every time I open workbook B I get the message "the workbook you opened contains automatic links to info in another workbook - do you want to update". How do I delete the link and stop this message appearing each time I open workbook B. Thanks in advance.

 

[Ian Mac]

Highlight the area with the links in.

Copy
Paste Special>Values

Regards.