How do I get rid of automatick links?

[JDT]

I made a copy of a spreadsheet, and have since added data to that new
spreadsheet. I no longer use the old sheet, but it has data on it I
want to keep.

However, every time I bring up the new spread sheet a box comes up
saying:

"The workbook you opened contains automatic links to information in
another workbook. do you want to update this workbook with changes
made to the other workbook?"

I would like to keep this from popping up all the time. Is there an
easy to go get rid of it?

Thanks.

 

[Gordon]

I made a copy of a spreadsheet, and have since added data to that new
spreadsheet. I no longer use the old sheet, but it has data on it I
want to keep.

However, every time I bring up the new spread sheet a box comes up
saying:

"The workbook you opened contains automatic links to information in
another workbook. do you want to update this workbook with changes
made to the other workbook?"

I would like to keep this from popping up all the time. Is there an
easy to go get rid of it?

Thanks.

Try here for the Findlink add-in:
http://www.bmsltd.ie/MVP/MVPPage.asp

 

[JDT]

Try here for the Findlink add-in:
http://www.bmsltd.ie/MVP/MVPPage.asp

I downloaded the program and it worked perfectly. Thanks.

 

[Gordon]

I downloaded the program and it worked perfectly. Thanks.

You're welcome - it's a very useful little utility that!