Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
xk xk is offline
external usenet poster
 
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic Email Link Seorges Excel Discussion (Misc queries) 1 September 5th 06 01:08 AM
Finding a Problem Link in Excel Tracy B. Excel Discussion (Misc queries) 3 May 2nd 06 07:18 PM
removing automatic link Graham Poole Excel Discussion (Misc queries) 8 March 22nd 06 02:31 PM
Breaking the link T New Users to Excel 1 May 4th 05 10:37 PM
Removing Link to Access Query a_ryan1972 Excel Discussion (Misc queries) 0 April 11th 05 05:38 PM


All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"