Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing automatic links to information in another workbook
Hello,
Whenever I open an Excel workbook, I got the following message: The workbook you opened contains automatic links to information in another workbook. ..... If i choose Edit--Links, I observed that this workbook is referring to some another workbook. I also know that the workbook referred does not exists presently. How to get rid-off this message? I do not want any external link in my workbook. How to remove reference of that workbook? Another case is, Whenever I open an Excel workbook, I get warning whether to enable or disable macros in the workbook as they may contain viruses. I observed that that workbook does not contain any macros, still the message persists. How to get rid-off this message? -Sameer |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing automatic links to information in another workbook
If you can find the formulas with links, you can convert those formulas to
values. I'd use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm to search for links to the other workbooks. Sameer wrote: Hello, Whenever I open an Excel workbook, I got the following message: The workbook you opened contains automatic links to information in another workbook. ..... If i choose Edit--Links, I observed that this workbook is referring to some another workbook. I also know that the workbook referred does not exists presently. How to get rid-off this message? I do not want any external link in my workbook. How to remove reference of that workbook? Another case is, Whenever I open an Excel workbook, I get warning whether to enable or disable macros in the workbook as they may contain viruses. I observed that that workbook does not contain any macros, still the message persists. How to get rid-off this message? -Sameer -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Links not updating in shared workbook | Excel Worksheet Functions | |||
Cut links between worksheets in same workbook | Excel Worksheet Functions | |||
Automatic Links | Excel Discussion (Misc queries) | |||
Automatic links in Excel 2003 | Excel Discussion (Misc queries) |