Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to get rid of an link message in Excel?
Hi,
I've copied and pasted two work sheets and merged them into a master workbook in Excel, and have micro in the master workbook. Now each time when I open the master workbook in Excel, it will have a message: "The workbook you opened contains automatic links to information in another workbook. Do you want to update the workbook with changes made to the other workbook?"... Is there a way to get rid of this message? Any help will be greatly appreciately. Thanks, Jenny |
#2
|
|||
|
|||
It sounds like you had formulas referencing another sheet in your original
workbook. You can do a Find/Replace, using[*] as the find and leaving replace with empty. You may need to do this in 1 sheet in the workbook. -- Good Luck, Peg "Jenny" wrote: Hi, I've copied and pasted two work sheets and merged them into a master workbook in Excel, and have micro in the master workbook. Now each time when I open the master workbook in Excel, it will have a message: "The workbook you opened contains automatic links to information in another workbook. Do you want to update the workbook with changes made to the other workbook?"... Is there a way to get rid of this message? Any help will be greatly appreciately. Thanks, Jenny |
#3
|
|||
|
|||
Hi Pegl,
Thanks for your quick response and help. I tried this way and get rid of all the references from the charts (data source link) and all the calculations. Once I saved the file and I still get the message when I open the file. Do you have any other suggestions? Is there anywhere (hidden references) that I didn't get rid of yet? Thank you very very much for all your help!!! Jenny "PegL" wrote: It sounds like you had formulas referencing another sheet in your original workbook. You can do a Find/Replace, using[*] as the find and leaving replace with empty. You may need to do this in 1 sheet in the workbook. -- Good Luck, Peg "Jenny" wrote: Hi, I've copied and pasted two work sheets and merged them into a master workbook in Excel, and have micro in the master workbook. Now each time when I open the master workbook in Excel, it will have a message: "The workbook you opened contains automatic links to information in another workbook. Do you want to update the workbook with changes made to the other workbook?"... Is there a way to get rid of this message? Any help will be greatly appreciately. Thanks, Jenny |
#4
|
|||
|
|||
When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm Jenny wrote: Hi, I've copied and pasted two work sheets and merged them into a master workbook in Excel, and have micro in the master workbook. Now each time when I open the master workbook in Excel, it will have a message: "The workbook you opened contains automatic links to information in another workbook. Do you want to update the workbook with changes made to the other workbook?"... Is there a way to get rid of this message? Any help will be greatly appreciately. Thanks, Jenny -- Dave Peterson |
#5
|
|||
|
|||
Hi Dave,
Thanks for your suggestions. By using Bill Manville's FindLink program, I find a file link and solve the problem. Thank you, jenny "Dave Peterson" wrote: When I can't find links, I'll use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Jenny wrote: Hi, I've copied and pasted two work sheets and merged them into a master workbook in Excel, and have micro in the master workbook. Now each time when I open the master workbook in Excel, it will have a message: "The workbook you opened contains automatic links to information in another workbook. Do you want to update the workbook with changes made to the other workbook?"... Is there a way to get rid of this message? Any help will be greatly appreciately. Thanks, Jenny -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error message in Excel after exporting Access query to Excel | Excel Discussion (Misc queries) | |||
want to link excel doc. to pdf. | Excel Discussion (Misc queries) | |||
Unexpected error message on closing an Excel file | Excel Discussion (Misc queries) | |||
most effective way to link ms word tables to excel | Excel Discussion (Misc queries) | |||
Open a file in excel from a link in eplorer | Excel Discussion (Misc queries) |