Deleting / Disabling the Links

Hello,

I have got 2 queries.
First one:
I have got a workbook which has so many links that points 
to various unknown files.

I have deleted some of the links by manually scanning the 
various sheets. but still i am left with some links which 
i could not find manually..

I have even cleared all the names in the workbook. Still 
no use.

I looked into Edit->Links, i can see one link, but 
unfortunately there is no delete button with which i can 
remove the link.

Can anybody help me how to remove the unknown link in the 
book? Thanks.

Second one:

Continuing from my prev question, whenever i open the 
books which contains some links, excel asks for links 
updation.

There is one option i saw in Tools->options -> Update 
remote references...that doesn't work..excel updates 
automatically without even asking.

Is there any way to control the automatic updation by 
choosing manual instead of automatic.

Thanks for your kind help.

Sri.







0
anonymous (74722)
11/20/2003 11:53:51 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
355 Views

Similar Articles

[PageSpeed] 16

"Sri" <anonymous@discussions.microsoft.com> wrote in message
news:0c7401c3af5c$f7462fd0$a301280a@phx.gbl...
> Hello,
>
> I have got 2 queries.
> First one:
> I have got a workbook which has so many links that points
> to various unknown files.
>
> I have deleted some of the links by manually scanning the
> various sheets. but still i am left with some links which
> i could not find manually..
>
> I have even cleared all the names in the workbook. Still
> no use.
>
> I looked into Edit->Links, i can see one link, but
> unfortunately there is no delete button with which i can
> remove the link.
>
> Can anybody help me how to remove the unknown link in the
> book? Thanks.
>
> Second one:
>
> Continuing from my prev question, whenever i open the
> books which contains some links, excel asks for links
> updation.
>
> There is one option i saw in Tools->options -> Update
> remote references...that doesn't work..excel updates
> automatically without even asking.
>
> Is there any way to control the automatic updation by
> choosing manual instead of automatic.
>
> Thanks for your kind help.
>
> Sri.

It's generally better to put only one question in a post.

Question 1:
There's a very good utility called Findlink that you can download free from
here:
http://www.bmsltd.co.uk/MVP/Default.htm

Alternatively, in Edit > Links, you can change the source to point to the
workbook itself (i.e. the one with the link in it that you're working on).
This will eliminate any reference to the other workbook, but somewhere there
will still be one (or more) formula (or whatever) that now contains an
ordinary 'internal' reference (or #REF!) rather than a link.

Question 2:
Under
Tools > Options > Calculation tab
there is a setting "update remote references". Is this what you are looking
for?


0
Paul
11/20/2003 1:43:11 PM
Reply:

Similar Artilces:

The Item could not be deleted. It was either moved or already deleted, or access was denied.
This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C42C5B.11C3D7B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I had to rebuild a corrupt database this morning. My Priv.edb and = Pub.edb were the files I worked on with the ESEUTIL. Everything is = working except users are complaining that they cannot delete e-mails = that were "zapped" during the rebuild process. The message they're = receiving is " The Item could not be deleted. It was either moved or = already deleted, or access was denied...

Autofill In Linked Forms
I have created a couple of forms by selecting all the fileds in the form wizard from two tables: 1. Suppliers (Fields: Supplier, Address, Contact, etc.) 2. Products (Fields: Supplier <Lookedup from Supplier Table>, Product, Rate, etc.) Upon clicking the toggle button on Suppliers form I have the Products form opened. However, as I enter the data in it, I want the Supplier filed in the same be automatically be filled with the Supplier name as in the opened Supplier form so as to be filtered and displayed the next time I open the same instead of manually inserting the sa...

Delete rows with true or false
Hi, I want to delete all the rows that contain the word true or false. How can I do this? Thanks Diana wrote: > Hi, > > I want to delete all the rows that contain the word true or false. How > can I do this? Can you sort on the column containing true or false, then select all the rows in one group and delete them? Or does it need to be automatic? -- Jordon If the data is in one column, you could apply data|filter|autofilter (in xl2003 menus) to that column. Show the rows that contain either True or False and delete the visible rows. Then remove the au...

disable unhide sheets on toolbar
Hello is there a way to dis-able the unhide sheets toolbar? TIA, Ditchy Hi Ditchy Protect the workbook (Tools > Protection menu) to prevent hiding, unhiding and renaming of sheets. HTH. Best wishes Harald "ditchy" <ditchy@ncable.net.au> skrev i melding news:1115110468.548181.247220@g14g2000cwa.googlegroups.com... > Hello > is there a way to dis-able the unhide sheets toolbar? > TIA, Ditchy > If you want to take out that control then use Application.CommandBars("Worksheet Menu Bar").Controls("Format").Controls("Sheet").Co...

Changing source links in powerpoint
I currently have a powerpoint with source links to other powerpoint slides. These source links are currently internet address based links. I'm trying to change these current internet addresses to new internet addresses and each time I try I receive the error message: "You cannot use an internet address here. Enter a path that points to a location on your computer or on the network". I've been able to change the source links in the past and only began to encounter this problem around mid December. Does anyone know how to correct this or explain why I can no ...

Disabling password feature on Personal Folders
I've upgraded from Outlook 2000 to 2002 and set up the user's Outlook profile. I go to add his Personal Folders and browse to his saved .pst file and the system asks us for an outlook password. I enter his Outlook password and I get the message that it is incorrect. The problem is the user says he never password protected his .pst file. So how do I - or can I - remove the password protection so that I am able to add his Personal Folders? Any help is greatly appreciated! ...

reconnect to mailbox after Disabling user?
Hello, I was wondering if there is a easier way then to recycle the Exchange Services to renable a mailbox after a users mailbox has been disabled for x amount of time. I want to give access to this mailbox to another user so right now.. I simply go to Mailbox Rights -> (add the user I want to add) -> give allow rights to Read / Full but this requires a recycle of the services. Is there another way without recycling the services? G. On Mon, 23 Aug 2004 11:08:36 -0400, "Just Another Admin" <just@dmin.net> wrote: >Hello, > >I was wondering if there ...

Unable to delete the Dead Domain controller
Dear, Iam working on windows server 2008 Ent Ed I have two doman controllers in the domain both are GC but only one domain controller has all the fsmo roles but iam having replicattion problems with the dead DC (i.e mppkw-database) and Iam unable to delete or remove the dead domain controller from the domain and iam having follwing problems using the ntdsutil :- matadata cleanup select operation target: list domains Found 1 domain(s) 0 - DC=mediaphoneplus,DC=com select operation target: select domain 0 No current site Domain - DC=mediaphoneplus,DC=com No current server N...

visited links no longer change color
The links still work when clicked but, no longer show purple when visited. This happens in both Outlook and Outlook Express. Yesterday I tried making fonts a little larger as I have eyesight problem. Not sure if this is when the link color problem started. What I did exactly is: *Tools > Options > Mail Format > click "Fonts" button > click "International Fonts" button * At first I went through the list making each one "Larger" font size. * I realized that it's probably only "Western European" I need to change, so all others were set ...

Re-exporting functions from dynamically linked DLL
Hi, I have the following situation: I have a 3rd party DLL which does not include a LIB file, just a header file with typedef declarations for exported functions (It is intended for dynamic linking) I need to wrap the DLL to allow for callbacks to my own code (in Lisp), and to do this I need to load the DLL using LoadLibrary and access each function that I need using GetProcAddress. So for example: The third party header will say: typedef INT (WINAPI * lp_function)(); Then in my c wrapper file: #include "3rdparty.h" #ifdef _WIN32 #define DllExport __declspec(dllexport) #else #...

time.h :Linking errors
Hi, I have an application where I am using the function like time(),gmtime() from time.h.My code compiles but I get linking errors. So Could you please tell which library needs to be included for time.h? Thanks in advance. Regards, Harish See the response to this exact same question that you asked yesterday -- Bruce Eitman (eMVP) Senior Engineer Bruce.Eitman AT Eurotech DOT com My BLOG http://geekswithblogs.net/bruceeitman Eurotech Inc. www.Eurotech.com "hari" <hari@discussions.microsoft.com> wrote in message news:11A4458D-67B1-49A9-B371-56A084A...

Remake deleted account in Windows Live Mail
Hi, is it possible to remae an acount I have removed from Windows Live Mail ? Or just a possibility to import the emails there was in the 2 account I removed ? I did not think the program would delete the emails, when I removed the account settings. Hope someone can help, as there are some emails I would like to save. Best wishes Steen Did you look on the web access for those accounts to see if the emails are still out there? "steendk" <steendk@discussions.microsoft.com> wrote in message news:652B3826-1F5C-4309-99DC-7EE579109C44@microsoft.com......

How do I keep a formula from changing if a row is added or deleted
I have a formulas referencing cells in another worksheet. When rows are added or deleted from the worksheet the formulas are either changed to skip the new row or receive an #REF! error when a row is deleted. Regardless of what happens in the worksheet I want the formulas to remain the same. Hi see your other post -- Regards Frank Kabel Frankfurt, Germany cwolt wrote: > I have a formulas referencing cells in another worksheet. When rows > are added or deleted from the worksheet the formulas are either > changed to skip the new row or receive an #REF! error when a row is >...

Alphanumeric links
Does anyone know how to change what the alphanumeric links at the bottom of each page link to? My leads are cool - if I click D, it gives me all the leads who's company name start with D. I want the same for opportunities, but they link to the topic, not the company. Any ideas? I've taken a quick look and I don't think it's possible to change how this works. You can specify "find columns" but that only works for advanced find and when you type something in the "look for" textbox. It doesn't work for the alphanumeric links. -- Jeffry van de Vuurs...

How to delete digits after period
I am working on a price list and want to delete the multiple digit after the period and permanmently on keep two. I know about th increase and decrease decimal. But I need to permanently delete th digits. Can anyone help -- Rogerm ----------------------------------------------------------------------- Rogermb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1673 View this thread: http://www.excelforum.com/showthread.php?threadid=31936 Hi =ROUND(A1,0) -- Regards Frank Kabel Frankfurt, Germany "Rogermb" <Rogermb.1g4s7z@excelforum-nospam.com> sch...

SafePay communication link
We just setup SafePay to work with our bank,, I would love to use the GP communication link option under "configurator",, but since the output file is sent to a network folder how should we upload the file to the bank,, If we use a FTP client is there one that the "link" will launch when the client uploads the file.. How to you automate the process all the way to the bank Thanks, ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button i...

Lock sets of cells in a row and sort by date linked to each set
I have a set of qualifications linked to a name that need to be presented in a row A = Name B = Qual Type 1 C = Expiry Date (eg 29/01/12) D = Qual Type 2 E = Expiry Date (eg 17/12/12) F = Qual Type 3 G = Expiry Date (eg 25/06/11) H = Qual Type 4 (has no expiry date) I want to sort each qualification into 'date expiry' order keeping it connected to the relevant Qual Type. Therefore, I want Qual Type 3 with it's exipiry date to move into Column B & C, Qual Type 1 with it's exipiry date to move into Column D & E and Qual Type 2 with it's exipiry da...

Scheduled Bills/Deposits being deleted by MSN Money!
Money 2k4 Deluxe and Money Central, win xp pro sp-1 tho I doubt this matter.. I have about 2 dozen scheduled bills or deposits set up. When I sync my account with MSN Money, I lose a number of these, they simply aren't listed anymore, although about 10 or so remain. For the life of me, I can't figure out WHY this is happening. For the moment, I'm simply not syncing with MSN money, but that's a less than optimal solution, as it means I have to manually download electronic statements for half a dozen bank accounts. I have before and after screenshots of the bills page, if seeing ...

Disable BU
A really quick one for you. If I disable a BU in MSCRM, does the corresponding OU in Active Directory become disabled? I think the answer probably 'No' as I actually cannot find a way to disable the OU manually and therefore cannot check, but if anyone has a definitive answer I would be grateful. Regards Peter John - thanks for your help. Regards Peter >-----Original Message----- >No, disabling BU in CRM will not disable corresponding OU in the AD, just like dissabling CRM user in CRM will not siable the corrsponding user in AD. > >"Pete" wrote: > &...

How can I insert a usuable underlined link within a Publisher doc
I cannot get our email or web page to be underlined for a "click on" feature when doing a newsletter in Publisher? Any ideas? Insert, hyperlink... -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "tinab" <tinab@discussions.microsoft.com> wrote in message news:2C3FAE95-60CC-4D45-8111-1D2A944A7FA8@microsoft.com... >I cannot get our email or web page to be underlined for a "click on" feature > when doing a newsletter in Publisher? Any ideas? ...

message shows horizontal and cannot be moved so cannot delete
when double clicking a message it shows up too wide and I cannot move it or shrink it so I can get to the right hand side to move it up or down or to delete it..How can I get it back to the right size?? Panda;1246564 Wrote: > when double clicking a message it shows up too wide and I cannot move it > or > shrink it so I can get to the right hand side to move it up or down or > to > delete it..How can I get it back to the right size?? Click and drag to where you can see it by clicking in the top of the window in which the message is showing. -- rhlhamlet ...

Delete key in open message
In Outlook 2003, is there a way to get the delete key to delete a message you've opened, just as it does if you're reading it in the preview pane? In other words, I'd like to open a message with the enter key, delete it with the delete key instead of having to click the "X", return to the message list, open the next message, etc. ==================================== Larry Wahlers, Systems Specialist Concordia Technologies The Lutheran Church - Missouri Synod ...

E-mail deleting attachments
How do I change my setting so Outlook Express does not automatically delete my attachments? It's not deleting them. It's a setting you control. See http://support.microsoft.com/default.aspx?scid=kb;en-us;329570&Product=winxp Hope this is useful to you. Let us know. rms Sean Smith wrote: > How do I change my setting so Outlook Express does not > automatically delete my attachments? ...

Edit data for Excel charts is disabled
Hi everyone, I think I asked this question before but I can't find it now. I use VBA to insert some Excel charts in PP 2007, sometimes the edit data option for charts is disabled and I can't edit the data for that specific chart , any suggestion how I can me it enable again? -- Best regards, Edward ...

Linking Journal Entries or Contacts?
How do we link related journal entries in Outlook 2007? Obviously, certain series of journal entries are related, just as an e-mail message thread is related. We would like to somehow link or group these entries so they can be followed as a chronological thread. Likewise, we would like to link certain contacts together as might be the case for all individuals working for the same company or for all the members of a family. In earlier versions of Outlook, we were able to associate contacts with each other, but do not see how to perform this same operation in Outlook 2007? Similarly,...