How do I get rid of automatick links?
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. |
JDT wrote:
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 -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
On Sun, 27 Feb 2005 21:13:56 -0000, "Gordon"
wrote: JDT wrote: 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 I downloaded the program and it worked perfectly. Thanks. |
JDT wrote:
On Sun, 27 Feb 2005 21:13:56 -0000, "Gordon" wrote: JDT wrote: 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 I downloaded the program and it worked perfectly. Thanks. You're welcome - it's a very useful little utility that! -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
All times are GMT +1. The time now is 02:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com