Removing a Link

How do I remove a link to another worksheet? I have a 
workbook which has several sheets containing links to each 
other within the workbook only. The mistake I made is that 
I copied one of the sheets to a new file in order to email 
just that sheet to somebody. My problem now is that my 
original workbook will not function properly as it thinks 
it is linked to the new file that I no longer need and 
have since deleted. There does not seem to be a 
straightforward way to delete a link to another workbook. 
How do I get back to where I was originally?
Any help would be greatly appreciated.
Regards
Michael
0
anonymous (74722)
5/21/2004 12:43:43 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
355 Views

Similar Articles

[PageSpeed] 8

Hi
try the following add-in to find/delete these links:
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FindLink.zip

--
Regards
Frank Kabel
Frankfurt, Germany

"MichaelD" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag
news:1034d01c43f31$405312b0$a501280a@phx.gbl...
> How do I remove a link to another worksheet? I have a
> workbook which has several sheets containing links to each
> other within the workbook only. The mistake I made is that
> I copied one of the sheets to a new file in order to email
> just that sheet to somebody. My problem now is that my
> original workbook will not function properly as it thinks
> it is linked to the new file that I no longer need and
> have since deleted. There does not seem to be a
> straightforward way to delete a link to another workbook.
> How do I get back to where I was originally?
> Any help would be greatly appreciated.
> Regards
> Michael

0
frank.kabel (11126)
5/21/2004 12:53:51 PM
How do you ADD a link to a page???
>-----Original Message-----
>Hi
>try the following add-in to find/delete these links:
>http://www.bmsltd.ie/DLCount/DLCount.asp?
file=FindLink.zip
>
>--
>Regards
>Frank Kabel
>Frankfurt, Germany
>
>"MichaelD" <anonymous@discussions.microsoft.com> schrieb 
im Newsbeitrag
>news:1034d01c43f31$405312b0$a501280a@phx.gbl...
>> How do I remove a link to another worksheet? I have a
>> workbook which has several sheets containing links to 
each
>> other within the workbook only. The mistake I made is 
that
>> I copied one of the sheets to a new file in order to 
email
>> just that sheet to somebody. My problem now is that my
>> original workbook will not function properly as it 
thinks
>> it is linked to the new file that I no longer need and
>> have since deleted. There does not seem to be a
>> straightforward way to delete a link to another 
workbook.
>> How do I get back to where I was originally?
>> Any help would be greatly appreciated.
>> Regards
>> Michael
>
>.
>
0
jjoyner1 (1)
5/21/2004 1:20:11 PM
Hi
simple version:
- enter the equation sign '='
- select with your mouse the source cell and hit ENTER

--
Regards
Frank Kabel
Frankfurt, Germany

"Janet" <jjoyner@healthcharitiesfla.org> schrieb im Newsbeitrag
news:1031901c43f36$5858b950$a101280a@phx.gbl...
> How do you ADD a link to a page???
> >-----Original Message-----
> >Hi
> >try the following add-in to find/delete these links:
> >http://www.bmsltd.ie/DLCount/DLCount.asp?
> file=FindLink.zip
> >
> >--
> >Regards
> >Frank Kabel
> >Frankfurt, Germany
> >
> >"MichaelD" <anonymous@discussions.microsoft.com> schrieb
> im Newsbeitrag
> >news:1034d01c43f31$405312b0$a501280a@phx.gbl...
> >> How do I remove a link to another worksheet? I have a
> >> workbook which has several sheets containing links to
> each
> >> other within the workbook only. The mistake I made is
> that
> >> I copied one of the sheets to a new file in order to
> email
> >> just that sheet to somebody. My problem now is that my
> >> original workbook will not function properly as it
> thinks
> >> it is linked to the new file that I no longer need and
> >> have since deleted. There does not seem to be a
> >> straightforward way to delete a link to another
> workbook.
> >> How do I get back to where I was originally?
> >> Any help would be greatly appreciated.
> >> Regards
> >> Michael
> >
> >.
> >

0
frank.kabel (11126)
5/21/2004 1:24:47 PM
Reply:

Similar Artilces:

Remove CAPS
I have a text box in a form called Description. I do not want users to be able to enter in here with all CAPS. They have been instructed, but there are still a few that occasionaly forget. I played around with the < and > in Format, but the description can be fairly long and using these will cut off some of the info. Is there any other code that will remove the CAPS if entered that way? However, I would prefer for it to keep the CAP in the beginning of a sentence. Thank you! -- Message posted via http://www.accessmonster.com On Wed, 02 Jun 2010 12:44:37 GMT, &quo...

Link to CRM tables from external application
My client has a mission-critical application that was written in Microsoft Access sitting on a SQL Server database. It is basically a Quotation management system. The client wishes to install CRM and I'm investigating how to migrate the Customer data from their Quotation system to CRM. I'm pretty confident I can do this without too much trouble (having identified the relevant tables in CRM - AccountBase and ContactBase). However, I then want to link directly to the CRM tables from within the Access application. Normally I'd do this by setting up a DSN and using it to pull in l...

Allow Links on record navigation pane to open in new window
We've been trying to add links to some of our internal custom pages onto a contact records navigation pane in the ISV.config. It appears the only way those work is to open the link into the form itself vs. opening the page in a new window. We've tried using HTML commands to open in a new window, but it won't even import teh ISV.config with that in there. It would be great if we could open in a new window from those links... ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion,...

Summarising lists by removing empty entries #2
I have a table in Excel of contracts of yearly revenues: 2002 2003 A 10 10 B 0 7 C 0 0 D 5 0 and I want to be able to create a summarised version, where the zeros are stripped out: 2002 A 10 D 5 2003 A 10 B 7 Sounds like there should be a vlookup-esque function for this... any ideas? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ Just eliminate the 0's? If your ranges don't have any errors in them: Copy to a new workshee...

Making links live in Outllok 07
My links have stopped being active in my messages when I type them in. As in they do not show an actual link but just plain text for the url. Even in HTML emails and those I send too also don't get a live active link. I've looked all over for this setting and can't seem to find what works. Could anyone please tell me how to make the links active when I simply input a url into my email message? (I do NOT want to have to do the whole "Insert URL" thing.) Thanks! Nancy You need to change the format of your messages to HTML. To do this try the following: ...

outlook 2007 blocked links in mails and "help"
My outlook 2007 refuses to open any link inside a mail or connect to links at all. If I click the "online help" button there is no reaction. If I click the "check for updates" button, the message is "failure to start browser". So, what's going on here? Anybody got an idea about what to do? -- Niels peter it sounds like the browser isn't properly registered. go to control panel, internet options and reset the browser settings. And in outlook, run help, office diagnostics. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ O...

Create Link to Dial-Up Network Item
Hello, I am using ishelllink to create links which is working, except I am struggling to get it to work with Dial-Up Networking entries. I can parse the namespace correctly and get the correct PIDL(matched with manual shortcut) for the item no problems, however passing the PIDL to SetIDList only creates a dead link. I have tried appending the PIDL's to make a PIDL relative to the Desktop to no avail. Any Ideas? I have never used COM objects before so I am lost for any. Any help would be greatly appreciated. Thanks. ...

remove cashier
When I log into POS and I log in as a cashier how do I remove the next screen that pops up and says please select cashier again? Manager | Configuration | Options | POS options| uncheck Prompt for sales rep. "Angelique" wrote: > When I log into POS and I log in as a cashier how do I remove the next screen > that pops up and says please select cashier again? ...

How to remove the first line indent in all paragraphs
How do I remove the first line indent in all paragraphs of a document i.e. so that all the text is flush left? It will depend on whether the first-line indent is created by actually indenting or by inserting a tab character. You can see this by viewing the ruler and also by viewing nonprinting characters (Ctrl+Shift+8) to see whether there is an arrow at the beginning of each paragraph. If the indent is caused by an actual indent, Ctrl+A to Select All and drag the First Line Indent marker back to the left margin. If there are tab characters, use Replace to search for ^t and re...

form / subform linking
I have a table containing projects and related data (tblProject) I want to build a form where the user can choose a project from a combobox and have a subform appear. This subform should contain 2 columns (“Project Activity” and “Project Activity Description”). I want the user to be able to use the subform to type the activities and their descriptions for the selected project, and I want this data to be stored in a table. So the next time user opens the form, he can select a project from the combobox and see or change its activities and descriptions. I don't know how to build the ...

Outlook 2000
The "Customize Outlook Today" link in the upper right of Outlook Today does not seem to work when running Outlook 2000 with SP3. Any ideas? I couldn't find anything in the FAQ's. ...

Links in tasks
I am using Outlook 2003. I apologise in advance if this is a very simple question, but I cannot find any way to insert a link within a task to a file on my computer. I do not want to insert the file, I simply want to insert a link to whatever document the task is related to. I thought I should be able to insert a hyperlink, but none of the toolbars will give me that option. Hector "Hector" <socialissues1954@yahoo.co.uk> wrote in message news:%23W0J9by3EHA.1396@tk2msftngp13.phx.gbl... >I am using Outlook 2003. I apologise in advance if this is a very simple > question,...

Disable ability to link in spreadsheet template
Hello Could anyone tell me how to disable the ability to link data in a cell for a spreadsheet? I would like to do this without using a macro. ...

Removing a CDockable Pane
This is an update to my previous thread "Dynamically creating CDockablePanes" What I want to do is to Create multiple CDockablePane(CDP) that will be destroyed when the user clicks the "X" Button. While it may seem trivial, I have ran into some hiccups When the CDP is docked, clicking the X will trigger an event that can be caught by DockablePane::OnPressCloseButton(). From there, I can then PostMessage(WM_CLOSE); and my CDP will be destroyed correctly The problem is that when you undock the CDP, MFC creates a MiniFrame and places your CDP inside it. Now when t...

Still getting Macro Security Warning Message after removing Macro
Excel 2002 SP3 Win XP Pro SP2 Hi, I had a macro in a spreadsheet which I ended up not needing. I removed it by going to VB Editor and removing the module containing the macro. However, I am STILL getting the Macro Security Warning when opening up the spreadsheet. How do I get rid of the warning? Or Could there be any trace of the macro left causing this warning? When going to View Macros (Alt+F8) that is blank/empty. Thanks. Go into the VBE once more (Alt-F11) and check if Modules is showing in the Project Explorer Window. If so, then right-click on the module and click on Remove M...

LINK : fatal error LNK1104: cannot open file "mfc71.lib"
Hi, I got the mfc71.dll, but i miss mfc.lib. Can someone tell me where to downloade this file. Thank you for your help. /Kai PS: I use MS c++ 6.0/Direct X 9.0c/G2DSDK ( with mfc71.dll,mfc71u.dll,msvcp71,msvcr71.dll... but i dont have the .lib-files?) try installing Visual C++ Toolkit 2003 "Kai" <Kai@discussions.microsoft.com> д���ʼ� news:9A073748-4027-4427-B39F-384E0573CC80@microsoft.com... > Hi, > I got the mfc71.dll, but i miss mfc.lib. Can someone tell me where to > downloade this file. > > Thank you for your help. > /Kai > > PS: I use MS c++ 6.0...

Outlook 6 will not send messages with web site links?
Hi, Please can you help me? I am having problems trying to send a word document (with a web site hyperlink) and the same link in the message body of an email. The word file is my CV and the link relates to my web site where examples of my work can be found (i.e nothing dodgy, im just looking for a new job). The word document has also been converted as pdf with the web site link. Both document links work fine outside of outlook express. The message will send (can see the progress bar), but it is not recieved and does not show up on the virgin server? I have sent this to my ...

Remove the entire Recipient list from the address book in Outlook
Hi all I'm using Exchange 5.5. I've been finding hi and low to remove the recipient list on the outlook client - address book. There is already a global address list in the address book, my users do not want to see the repeating list appears in the Recipient list. I saw many posting on this but so far couldn't see any possible resolution. I've tried the address book view suggestion. thank you for all suggestions.. eva@addon.com.sg (eva) wrote: >Hi all > >I'm using Exchange 5.5. I've been finding hi and low to remove the >recipient list on the outlook cli...

Problem: Deleted bill can't be removed from budget (Money 06)
I created a monthly split-category bill that needed to be an "only once" bill, and I accidentally entered into the register, so I deleted the bill, deleted the transaction in the register, and created a new "only once" bill. Now my budget shows double the amount of the categories in the bill because it still shows the monthly bill as well as the new "only once" bill. How do I delete the non-existent monthly bill from my budget? Schedule an "only once" deposit of the same amount to the same category. Enter the deposit and then delete the transac...

How to link tables using VBA
Does anyone know where can I found vba code to link tables using VBA? I can link the tables with the "Link Manager" but would like to do the linking using vba. Any suggestions or guidance. Luis -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200803/1 See here: http://www.mvps.org/access/tables/tbl0009.htm And several other pages on this site - click on the "Tables" link at the left of screen. HTH, Rob "luis_a_roman via AccessMonster.com" <u41449@uwe> wrote in message news:816a0338ac0ed@uwe... &g...

Batch removal of empty cells in Excel
Hi folks I am importing data from the EPRIME (psych experimentation) software These files log reaction times and responses, etc. The problem is tha the clolumns contain some cells with no information and are blank, e.g Resp1.ACC ... repeated for 48 columns (variables) <empty> 3 <empty> <empty> 4 <empty> 0 <empty> <empty> <empty> 5 <empty> 0 ....etc, in 36 rows How can I remove these empty cells, without having to do it manually? Regards - MF -- MFGPosted from http://www.pcreview.co.uk/ newsgroup acces You want to remove the empty ...

Can't link a table to excel within a Filling in Form protected doc
Got a document form that has a table that is a link to a Excel spreadsheet so that users can have the luxury of Excel's summing, I need to make the document protected with the Filling in Forms option, but that means the Excel link is not going to work, as it becomes a protected field. Is there a workaround for this, please. ...

how to remove unwanted fields from customizable form
Our's is a service based company so we do not need shipping address in MS CRM. Dependencies are removed via Deployment Manager and the Mappings setting for each object. In the case of addresses there are a lot of mappings, (i.e., contacts > quotes, accounts > quotes, quotes >orders, quotes > invoices, etc. I have removed dependencies using entity mapper in Deployment Manager but could not get rid of shipping address from the forms. It gives an error message: The field you are trying to remove is required by the system or business or an event dependent field. I have also ...

Linking Two Combo Boxes
Hello all, I have a list of data in a Combo Box A in Sheet 1. The data in Combo Box A is as following:- 1) Liverpool 2) Man Utd 3) Chelsea Now, I want one more combo box (i.e. Combo Box B) in front of Combo Box A. If I select Liverpool in Combo Box A, then automatically a list of Liverpool players appears in Combo Box B. And if I select Man Utd in Combo Box A, then automatically a list of Man Utd players appears in Combo Box B and so on. Can this be done? Please help me show how to go about it. Thanks. Zainuddin Hi again, Debra Dalgleish show how to do it on...

Opening PPT 2007 slides from .htm link
I created several training presentations in PPT 2003. Each presentation is linked to a common index file created in PPT 2003 and saved as an HTML document. When I open the files in PPT 2007, the link opens the presentation in PPT, instead of as a full-screen slide show as it did in PPT 2003. How can I open the presentations from the index file link as a full-screen slide show? Thanks! In article <E909F346-A051-49D3-A8B2-DD06614FC61A@microsoft.com>, Paul wrote: > I created several training presentations in PPT 2003. Each presentation is > linked to a comm...