Undoing LINKS in Excel 2000

I am Using Excel 2000 and I have a worksheet that is LINKED to data in a 
completely seperate workbook that was deleted weeks ago.  I still get the 
annoying boxes that say "file not found."  How do I UNDO the links that still 
exist to this files that was deleted?
0
jayceejay (27)
1/4/2005 4:45:07 PM
excel.newusers 15348 articles. 2 followers. Follow

3 Replies
496 Views

Similar Articles

[PageSpeed] 25

Hi
use the following addin to find these links:
goto: http://oaltd.co.uk/MVP/Default.htm

and search for Findlink.zip
(http://oaltd.co.uk/DLCount/DLCount.asp?file=FindLink.zip)

-- 
Regards
Frank Kabel
Frankfurt, Germany
"jayceejay" <jayceejay@discussions.microsoft.com> schrieb im Newsbeitrag 
news:929ED986-BFFB-4DF0-A635-DF8628A46DDA@microsoft.com...
>I am Using Excel 2000 and I have a worksheet that is LINKED to data in a
> completely seperate workbook that was deleted weeks ago.  I still get the
> annoying boxes that say "file not found."  How do I UNDO the links that 
> still
> exist to this files that was deleted? 


0
frank.kabel (11126)
1/4/2005 5:10:34 PM
I am in a network environment with a firewall that will not allow me to 
download any add-ins.  How do I fix using existing tools?

"Frank Kabel" wrote:

> Hi
> use the following addin to find these links:
> goto: http://oaltd.co.uk/MVP/Default.htm
> 
> and search for Findlink.zip
> (http://oaltd.co.uk/DLCount/DLCount.asp?file=FindLink.zip)
> 
> -- 
> Regards
> Frank Kabel
> Frankfurt, Germany
> "jayceejay" <jayceejay@discussions.microsoft.com> schrieb im Newsbeitrag 
> news:929ED986-BFFB-4DF0-A635-DF8628A46DDA@microsoft.com...
> >I am Using Excel 2000 and I have a worksheet that is LINKED to data in a
> > completely seperate workbook that was deleted weeks ago.  I still get the
> > annoying boxes that say "file not found."  How do I UNDO the links that 
> > still
> > exist to this files that was deleted? 
> 
> 
> 
0
jayceejay (27)
1/4/2005 5:47:05 PM
This is a multi-part message in MIME format.

------=_NextPart_000_002C_01C4F25D.0EA19F90
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

From the Excel help menu-----

Break links

Break a link to a source

Important When you break a link to a source, all formulas that that use =
the source are converted to their current value. For example, the link =
=3DSUM([Budget.xls]Annual!C10:C25) would be converted to =3D45.=20

Because this action cannot be undone, you may want to save a version of =
the file before you start.

On the Edit menu, click Links.=20
In the Source list, click the link you want to break.=20
To select multiple linked objects, hold down CTRL and click each linked =
object.=20
To select all links, press CTRL+A.=20
Click Break Link.=20
If the link used a defined name, the name is not automatically removed. =
You may want to delete the name as well.=20
How?
On the Insert menu, point to Name, and then click Define.=20
In the Names in workbook list, click the name you want to change.=20
Do one of the following:=20
Change the name
Type the new name for the reference, and then click Add.=20
Click the original name, and then click Delete.=20
Change the cell, formula, or constant represented by a name
Change it in the Refers to box.=20
Delete the name=20
Click Delete.=20
If you use an external data range, a parameter of a query may also use =
data from another workbook. You may want to check for and remove any of =
these type of links.=20
Control the startup prompt for updating links
Don't prompt for all workbooks I open, and update the links =
automatically
This option is for the current user only, and affects every workbook =
opened. Other users of the workbook are not affected.
On the Tools menu, click Options, and then click the Edit tab.=20
Clear the Ask to update automatic links check box. If the box is =
cleared, the links are automatically updated, and no alert is displayed. =

Prompt in the same way for every user of the workbook
Warning   This option affects all users of the workbook. If you choose =
to not update links, and not to prompt, users of the workbook will not =
know the data is out of date.
On Edit menu, click Links.=20
Click Startup Prompt.=20
Select the option you want.=20
Note You will still be notified if there are any broken links.
Replace a single formula with its calculated value=20
Caution   When you replace a formula with its value, Microsoft Excel =
permanently removes the formula. If you accidentally replace a formula =
with a value and want to restore the formula, click Undo  immediately =
after you enter or paste the value.
Select the cell that contains the formula.=20
If the formula is an array formula, select the range that contains the =
array formula.=20
How?=20
Click any cell in the array range.=20
On the Edit menu, click Go To.=20
Click Special.=20
Click Current array.=20
Click Copy .=20
Click Paste  on the Standard toolbar.=20
Click the arrow next to Paste Options , and then click Values.=20



"jayceejay" <jayceejay@discussions.microsoft.com> wrote in message =
news:2D89B460-0A9E-4F32-9882-9036F9F8C3E5@microsoft.com...
: I am in a network environment with a firewall that will not allow me =
to=20
: download any add-ins.  How do I fix using existing tools?
:=20
: "Frank Kabel" wrote:
:=20
: > Hi
: > use the following addin to find these links:
: > goto: http://oaltd.co.uk/MVP/Default.htm
: >=20
: > and search for Findlink.zip
: > (http://oaltd.co.uk/DLCount/DLCount.asp?file=3DFindLink.zip)
: >=20
: > --=20
: > Regards
: > Frank Kabel
: > Frankfurt, Germany
: > "jayceejay" <jayceejay@discussions.microsoft.com> schrieb im =
Newsbeitrag=20
: > news:929ED986-BFFB-4DF0-A635-DF8628A46DDA@microsoft.com...
: > >I am Using Excel 2000 and I have a worksheet that is LINKED to data =
in a
: > > completely seperate workbook that was deleted weeks ago.  I still =
get the
: > > annoying boxes that say "file not found."  How do I UNDO the links =
that=20
: > > still
: > > exist to this files that was deleted?=20
: >=20
: >=20
: >
------=_NextPart_000_002C_01C4F25D.0EA19F90
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff background=3D"">
<DIV><FONT face=3D"Franklin Gothic Demi">From the Excel help=20
menu-----<BR><BR>Break links</FONT></DIV><FONT face=3D"Franklin Gothic =
Demi">
<DIV><BR>Break a link to a source</DIV>
<DIV><BR>Important When you break a link to a source, all formulas that =
that use=20
the source are converted to their current value. For example, the link=20
=3DSUM([Budget.xls]Annual!C10:C25) would be converted to =3D45. </DIV>
<DIV>&nbsp;</DIV>
<DIV>Because this action cannot be undone, you may want to save a =
version of the=20
file before you start.</DIV>
<DIV><BR>On the Edit menu, click Links. <BR>In the Source list, click =
the link=20
you want to break. <BR>To select multiple linked objects, hold down CTRL =
and=20
click each linked object. <BR>To select all links, press CTRL+A. =
<BR>Click Break=20
Link. <BR>If the link used a defined name, the name is not automatically =

removed. You may want to delete the name as well. <BR>How?<BR>On the =
Insert=20
menu, point to Name, and then click Define. <BR>In the Names in workbook =
list,=20
click the name you want to change. <BR>Do one of the following: =
<BR>Change the=20
name<BR>Type the new name for the reference, and then click Add. =
<BR>Click the=20
original name, and then click Delete. <BR>Change the cell, formula, or =
constant=20
represented by a name<BR>Change it in the Refers to box. <BR>Delete the =
name=20
<BR>Click Delete. <BR>If you use an external data range, a parameter of =
a query=20
may also use data from another workbook. You may want to check for and =
remove=20
any of these type of links. <BR>Control the startup prompt for updating=20
links<BR>Don't prompt for all workbooks I open, and update the links=20
automatically<BR>This option is for the current user only, and affects =
every=20
workbook opened. Other users of the workbook are not affected.<BR>On the =
Tools=20
menu, click Options, and then click the Edit tab. <BR>Clear the Ask to =
update=20
automatic links check box. If the box is cleared, the links are =
automatically=20
updated, and no alert is displayed. <BR>Prompt in the same way for every =
user of=20
the workbook<BR>Warning&nbsp;&nbsp; This option affects all users of the =

workbook. If you choose to not update links, and not to prompt, users of =
the=20
workbook will not know the data is out of date.<BR>On Edit menu, click =
Links.=20
<BR>Click Startup Prompt. <BR>Select the option you want. <BR>Note You =
will=20
still be notified if there are any broken links.<BR>Replace a single =
formula=20
with its calculated value <BR>Caution&nbsp;&nbsp; When you replace a =
formula=20
with its value, Microsoft Excel permanently removes the formula. If you=20
accidentally replace a formula with a value and want to restore the =
formula,=20
click Undo&nbsp; immediately after you enter or paste the =
value.<BR>Select the=20
cell that contains the formula. <BR>If the formula is an array formula, =
select=20
the range that contains the array formula. <BR>How? <BR>Click any cell =
in the=20
array range. <BR>On the Edit menu, click Go To. <BR>Click Special. =
<BR>Click=20
Current array. <BR>Click Copy . <BR>Click Paste&nbsp; on the Standard =
toolbar.=20
<BR>Click the arrow next to Paste Options , and then click Values.=20
<BR><BR><BR><BR>"jayceejay" &lt;jayceejay@discussions.microsoft.com&gt; =
wrote in=20
message news:2D89B460-0A9E-4F32-9882-9036F9F8C3E5@microsoft.com...<BR>: =
I am in=20
a network environment with a firewall that will not allow me to <BR>: =
download=20
any add-ins.&nbsp; How do I fix using existing tools?<BR>: <BR>: "Frank =
Kabel"=20
wrote:<BR>: <BR>: &gt; Hi<BR>: &gt; use the following addin to find =
these=20
links:<BR>: &gt; goto: http://oaltd.co.uk/MVP/Default.htm<BR>: &gt; =
<BR>: &gt;=20
and search for Findlink.zip<BR>: &gt;=20
(http://oaltd.co.uk/DLCount/DLCount.asp?file=3DFindLink.zip)<BR>: &gt; =
<BR>: &gt;=20
-- <BR>: &gt; Regards<BR>: &gt; Frank Kabel<BR>: &gt; Frankfurt, =
Germany<BR>:=20
&gt; "jayceejay" &lt;jayceejay@discussions.microsoft.com&gt; schrieb im=20
Newsbeitrag <BR>: &gt;=20
news:929ED986-BFFB-4DF0-A635-DF8628A46DDA@microsoft.com...<BR>: &gt; =
&gt;I am=20
Using Excel 2000 and I have a worksheet that is LINKED to data in a<BR>: =
&gt;=20
&gt; completely seperate workbook that was deleted weeks ago.&nbsp; I =
still get=20
the<BR>: &gt; &gt; annoying boxes that say "file not found."&nbsp; How =
do I UNDO=20
the links that <BR>: &gt; &gt; still<BR>: &gt; &gt; exist to this files =
that was=20
deleted? <BR>: &gt; <BR>: &gt; <BR>: &gt;</FONT></DIV></BODY></HTML>

------=_NextPart_000_002C_01C4F25D.0EA19F90--

0
nospam202 (664)
1/4/2005 5:58:16 PM
Reply:

Similar Artilces:

How to use outlook address in Excel
Hello, I have an Excel sheet which I use as an invoicing-application. I would like to retrieve address-data from Outlook where I keep all my contact-data of my customers. So, I want to select a customer from my Outlook contactlist when I am writing a new invoice in Excel. In Word, I have a macro which does this, but unfortunately the Application.GetAddress does not work in Excel. Can somebody help me ? "Henny Slokker" wrote: > Hello, > > I have an Excel sheet which I use as an invoicing-application. I would like > to retrieve address-data from Outlook where I...

Excel Drop Down Box
I'm trying to edit an excel worksheet that has drop down boxes. However, the drop down boxes are not typical forms. These drop dow boxes appear to be normal cells (They contain text). When I click o the box, a little gray box shows up w/ a down arrow to the right of th cell. However, if you right click on the cell, there aren't an property options that are displayed. I was wondering if anybody had any idea what kind of drop down box thi is. How can I edit or create one -- Message posted from http://www.ExcelForum.com It sounds like it's under Data|Validation. chris313 wr...

Outlook 2000 under Win98
Hi, Have a machine with Win98 and Outlook 2000. I am giving this machine to another user. The problem that I have is that when I start Outlook 2000, it has the previous user name in the splash screen. here are the things that I have tried. 1. Uninstall Outlook 2000 (twice) 2. Delete all occurances of Outlook in Registry 3. Reinstall Outlook 2000 (twice) 4. Delete .pwl files And still when I reinstall again, I entered a new user name in the installation process. After that, I start Outlook and still have the previous user name. Note: Don't really want to reinstall Win98. Any s...

Pasting data from Excel
Hello everyone, I'm not sure if I should be posting this question here or in the Excel forum but here goes. Is it possible to copy data from multiple cells in Excel and then paste them into multiple lines of the criteria section of an Access query? For example, Given cells and values: A1- 1 A2- 2 A3- 3 I would like to be able to copy this data from Excel and paste it into an Access query like : Criteria: 1 or: 2 3 I am using Access 2002 SP3 and Exc...

how to select multiple text boxes in excel for formatting
I am trying to select multiple text boxes for formatting the font but seem unable to select all of them other than to click on each one individually. Is there an easy way to select all of the text boxes at once? To select multiple objects on the sheet -- Click on one object Hold the Ctrl key, and click on additional objects To select all the objects on the sheet -- Choose Edit>Go To, click Special Select Objects, click OK Or, to work with specific objects, you can add the 'Select Multiple Objects' tool to one of your toolbars: Choose Tools>Customize Select the Commands tab...

excel margin issues on landscape
When I print a spreadsheet I cant get it to print to the full page - it prints smaller unlike older excel program. Also when i set the margins for a spreadsheet the left hand margin wont move over to the edge of page like right hand side? In Page Setup: If you are using the Scaling option to print to a certain number of pages wide by pages tall and/or you are using the columns to repeat at left, try: - clearing the number of pages tall value (so that it is blank), and/or - if you are printing to one page wide, remove the columns to repeat at left Simon "Peter MB" wrote: >...

Linking message
Hi, I've a database that's linked to the Inbox of my Outlook,Is there a way to create a button that once i click on it opens the message itself from the Outlook? Regards ...

Excel macro list
In Excel 2003 I used to be able to list all macros in a workbook by pressing Alt+F8. Now all I get is a series of ribbon help letters... What's changed? Is there still a way of accessing macros via Alt+F8? Any suggestions appreciated. Hi, ALT+F8 works for me in E2007. What do you mean by 'I get is a series of ribbon help letters' Mike "pbaker6" wrote: > In Excel 2003 I used to be able to list all macros in a workbook by pressing > Alt+F8. Now all I get is a series of ribbon help letters... What's changed? > Is there still a way of...

Can I only allow printing to pdf in Excel?
I have created a template in Excel which has been set up so that the layout is perfect when printing to pdf (which is how the document will mostly be used) but the layout changes if printing direct to our printer. Is there a way that I can ONLY allow printing to pdf from this document? Hello You may consider using some VBA to achieve this. One way is to use the Workbook_BeforePrint event and specify the pdf printer in the PrintOut method, eg: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PrintOut copies:=1, ActivePrinter:="CutePDF Writer on CPW2:" End Sub Pl...

GUID/Outlook format link giving error "Unable to open the seleted folder or item"
Hi, I have created custom forms in multiple public Outlook folders and when I send the GUID type link to the user, they receive an error: "Unable to open the seleted folder or item". The same happens if I send the Outlook type link. However, if I ask the user to go to the folder and find the appropriate posting, then the form opens and after that the link works, too. Is this due to some Exchange server setting? My clients are not the type that tolerate opening the form the long way, they want a one click solution. Please help, this is driving my team crazy. Any ideas are welcome...

query will not write to excel
I have set up a query to a Foxpro .dbf file in a database from excel. When I tell Excel to import the data it it appears to be working but never seems to return the data. Running the same query via msquery.exe returns the data with no problem. Can anyone tell me what the problem is ? ...

EXCEL FORMULA #28
Good afternoon, I'm trying to fine a formula which would show me how much money I would save on a mortgage if I were to pay additional principal each month--in addition to paying the additional principal how long would it take to pay off. I'm looking at a 160k mortgage at 7.5 for 30 years. I'll like to pay this off as soon as possible by paying additional principal each month. There are tons of free templates at: http://office.microsoft.com/en-us/default.aspx Maybe you'll find something you like. Kam1999i wrote: > > Good afternoon, > > I'm ...

OLE: Excel.Application
Hello, in VB.Net, I use Excel to display results : dim xl as new Excel.Application // creates an Excel process // snip (putting values into cells) xl.Visible = true If the user closes the Excel file and then my program, the Excel process is killed in memory, which is good. If the user closes my program first and then the Excel file, the Excel process remains in memory ! How can I make sure the process will be killed ? Thanks ! Hi You need to set xl.quit (and before that ensure that excel doesn't halt and ask things like "save changes?" on quitting) somewhere in your p...

Export relationship information from Visio to Excel
Hello all, Is there a way to export information regarding relationships from a visio diagram to an excel spreadsheet? In addition, is there a way to tell the excel spreadsheet to eliminate or change a relationship and for that action to be applied onto the visio diagram? thanks, ivan as a general answer I'd have to say "no, not without custom code". You didn't define what you meant as a relationship. al "Ivan Salas" <IvanSalas@discussions.microsoft.com> wrote in message news:6332A594-E4AF-4E8B-BA2D-7A4BC17962B3@microsoft.com... > Hello all, > &...

startup excel euro symbol
when i digit € symbol inside any application excel 2007 automacic startup and for me is impossible to use this symbol anywhere, i use windows xp professional ..have you a response to solve this problem? thanks ...

Excel 2003 Print Issue
I have created a spreadsheet to help with a university engineering assignment and I have added a worksheet that is basically an automatically generated report of all the calculations. I have set the Print Area up in such a way so that the results are printed out in well defined pages (e.g. page 1: title page, page 2: summary of input variables, page 3: summary of calculation results etc). The report is arranged vertically in the worksheet, so the pages are 'stacked' on top of each other. It prints out fine in Excel 2000 and 2002 but I recently upgraded to Excel 2003 and now find tha...

Linking multiple sheets
I need to set up a spreadsheet that links to 12 others. On each of the others there may be 100 rows(or less) of information to bring in to the master. Is it possible to write a formula that enables the link to pull in only rows that contain information? I don't want blank rows between each of the 12 groups of information I'm sure an expert will chime in with something better, but I've done similar with lookup functions. don't do it direct or it will be slow. I let everything come over to one master workbook, then use a lookup page that consolidates the data. "...

Named Ranges -- Link Issue?
I am working on a very large Excel workbook (231 worksheets, all inter-linked to one another). Each worksheet contains a number of named ranges (for the entire workbook, there are 6,117 named ranges). This appears to be causing a problem such that if I modify a cell on Worksheet1, and Worksheet2 is dependent on the value, Worksheet2 does NOT change UNLESS I rename Worksheet1. (I can rename it to _Worksheet1 and then back to Worksheet1, but again, unless I actually *change* the name, the link is not updated). Calculation is set to automatic (but even if I force calculation, be it on ...

excel 2000 message
excel 2000 message - 'cannot use object linking and embedding' Were they hit by the MSBlast worm? One poster (Lutz Meyer) guessed that this was the cause of his problems. I haven't seen any confirmation/denial, but you may want to read his post: http://groups.google.com/groups?threadm=3F3971AF.FA4490F5%40msn.com Post back with your results. I'm curious if that was the problem. (It's come up quite a few times since MSBlast hit.) bill bootle wrote: > > excel 2000 message - 'cannot use object linking and > embedding' -- Dave Peterson ec35720@msn.c...

Excel Graphing Line References off when chart is a sheet.
I have noticed that when any graph is created in EXCEL and you hover you mouse over the dataline you receive that corect response. If you convert the chart to a sheet, the hover of the data line is now not representative of the the y axis directly below it. The data being graphed is correct now the hover represents the "series" (x-Axis) correctly but does not represent the "Point" (y-axis) correctly at all. Tne Y-axis datapoint reference is wrong. Any help? ...

Editable Excel Spreadsheet Online?
Hi, I tried to recent find information on this, but could find very little. How difficult would it be to host an excel spreadsheet online where visitors to the site can directly view and edit it? Right now, I can upload the spreadsheet to our web site and visitors can view it, but if they edit it, they can only save it to their local drive. I would like the users to be able to save the copy on the server. What would be involved in something like this? I assume for starters (if it's do-able) we'd need Windows hosting (we're not hosting ourselves) and some ASP support. Any de...

how do I delete documents from the start list in word and excel?
how do I delete documents from the start list in word and excel? You can not clear it whenever you want. You can however set the no of file names to be displayed to 0 which clears the list... In Excel 2003 Tool->Options->General Enter 0 against 'Recently Used File List' of clear the check box. Click 'OK' Word has a similar option. For 2007 versions or if you want to play with Registry Settings (not advised unless you understand it well) see http://www.mydigitallife.info/2008/01/13/how-to-clear-and-delete-recent-documents-list-in-office-2007-word-excel-p...

Error saving Excel files in a network drive
I have a problem saving Excel files onto a network drive. I get an error saying it was imposible to save the file. It creates a temporary file and then I have to open it and save it as a new document. This issue doesn�t occur saving the file in my hard disk. This happens with "Full control" access to the shared folder... I have Windows XP and Office 2000. Thanks in advance Mateo. Hi Mateo, > I have a problem saving Excel files onto a network drive. I get an error > saying it was imposible to save the file. It creates a temporary file and > then I have to open it and sav...

Import contacts from Excel into Outlook Contacts
I know this can be done from the import function in Outlook but how does one control where each field goes? There's a Map Fields step in the wizard. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Maurice" <anonymous@discussions.microsoft.com> wrote in message news:5e0a01c48154$f16ff9e0$a401280a@phx.gbl... > I know this can be done from the import function in > Outlook but how does one control where each field goes? ...

How do I print grayscale font in Excel 2003?
In print preview, and on printed pages, all colored font shows up as black. White font stays white. Font colors are displayed correctly in the worksheet. I have already tried the following: -> uncheck "black and white" in page setup -> change printer resolution, etc. -> creating a new workbook, typing some sample text and changing the color: the problem is not confined to one workbook. -> gray cell shading prints as gray: the problem is confined to fonts. -> colored font in Word previews and prints as displayed: the problem is confined to Excel. -> Excel help ...