Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing automatic link
Hi,
I got an issue about excel link. I did search and find this posting. Firstly, Bill's Add-in is really useful. But after run it, I still have the problem here. When I get to Edit/Link, it shows there is link called "Adj", but no any location info for this link. then I ran 'Find Link' , all the link regarding 'Adj' are those one which links between the sheets within this file, no any with out source file. So everytime I open file, it always prompt to ask update or don't update for link with the out source file. Is there anyone have an idea about this issue? Why the link within the file is got listed in "links" and prompted to ask update? Or is there any hidden link here? Any idea would be appreciated xk "David McRitchie" wrote: Before or after installing it ? To install first unzip the file into a folder. If you don't have a program to unzip then you can get one free for home use here http://www.ultimatezip.com There will probably be instructions, if not, Tools, Addins, but you will have an .xla file which you can install by going to Tools, Addins, Browse button to locate your addin. If you put your addin in one of the folders indicated in the help for the the Browse button is would already be listed, check the box and your addin is installed. I believe the initial find is set up for #REF! which is a broken link print appropriate button. I think there is the ability to look at a summary listing rather than anwering to delete each link or not as encountered. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Billing Goddess" <Billing wrote in message ... Thank you, but I am not sure how this add in works? Can you assist? "Frank Kabel" wrote: Hi try the following add-in to find/delete links: http://www.bmsltd.ie/DLCount/DLCount...e=FindLink.zip -- Regards Frank Kabel Frankfurt, Germany Billing goddess wrote: Is there a way in Office 2000 that a link between two workbooks can be removed? I know in 2003, when you click on edit/link you can remove the link, but i cannot locate the function in office 2000... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Email Link | Excel Discussion (Misc queries) | |||
Finding a Problem Link in Excel | Excel Discussion (Misc queries) | |||
removing automatic link | Excel Discussion (Misc queries) | |||
Breaking the link | New Users to Excel | |||
Removing Link to Access Query | Excel Discussion (Misc queries) |