Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links to other files | Excel Discussion (Misc queries) | |||
HELP!!! Missing Links!!! | New Users to Excel | |||
Update Individual Links | Excel Discussion (Misc queries) | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) | |||
Why do my links break when I burn multiple Excel files to a CD? | Excel Worksheet Functions |