FInding external link

When I open a spreadsheet, I get asked if I want to update external links. There 
shouldn't be external links in this spreadsheet, so I must have accidentally 
left in a formula which I need to change to a value. But I can't find the 
offending cell.

How do I search for a formula with an external link in it?

-- 
Thanks,
Fred



0
fredsmith99 (155)
8/31/2005 1:46:44 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
391 Views

Similar Articles

[PageSpeed] 50

Hi Fred,


Try Bill Manville's FindLinks addin which is freely downloadable at:

    http://www.oaltd.co.uk/MVP/Default.htm


---
Regards,
Norman



"Fred Smith" <fredsmith99@yahoo.com> wrote in message 
news:up6TR3crFHA.2228@TK2MSFTNGP10.phx.gbl...
> When I open a spreadsheet, I get asked if I want to update external links. 
> There shouldn't be external links in this spreadsheet, so I must have 
> accidentally left in a formula which I need to change to a value. But I 
> can't find the offending cell.
>
> How do I search for a formula with an external link in it?
>
> -- 
> Thanks,
> Fred
>
>
> 


0
normanjones (1047)
8/31/2005 1:54:56 AM
Reply:

Similar Artilces:

need a product key after downloading Can't find it
Why such a complicated way to download a Microsoft office free trial. Can't use it as I can't find the product key. This is just not necessary. How much time do I have to spend on this to be able to use the free trial download? If you tell me to follow the suggestions, I have, but can't find the source. -- elixer Trial product key displayed on the page from which you download trial Project. Follow the lnk http://office.microsoft.com/en-us/project/HA101672711033.aspx and download software once again. On the last step before actual downloading you will see the ...

Splitting Linked Files
I have 3 files used for materials management. They each contain data crosslinked from file to file. The files have become quite large and editing each is being impaired due to the size of the files. Will splitting the files into several smaller files improve performance? The links would still remain but each file would have a maximum of 25 or so worksheets nstead of the 200 currently in the largest of the 3. Any input is appreciated. -- Like a duck on a pond, stay calm on top and paddle like hell underneath. ...

Linking two documents so they open simultaneously
How do I link two documents so that one of them opens up when the other is openned? For example, I am working on a main document and there is a reference list that I stored as a different document. Is there a way to link the two so that when I open the main document, the reference document will automatically open? Thnx In your main document, you can insert a link to the reference list. Assuming that you are using Word 2007, here's how to do that: Place the insertion point at the appropriate location. On the Insert tab, click the arrow next to Object, and then click Text fro...

Does any one know how to globally remove links in an excel spread.
Here's one way: http://j-walk.com/ss/excel/usertips/tip031.htm Good luck. Regards, Kevin EAsham Download Bill Manville's FINDLINK.XLA from Stephen Bullen's site. http://www.oaltd.co.uk/Default.htm With this add-in you can find and delete links if any exist. Gord Dibben Excel MVP On Wed, 19 Jan 2005 12:21:03 -0800, EAsham <EAsham@discussions.microsoft.com> wrote: ...

Linked header and footer file/image
Hi, I am trying to find a way to link all of our publisher documents to stored header & footer images or files. I surpose this is a dynamic document. e.g. If I want to change a telephone number on the footer, I would edit one file, and this would replicate across all documents (much the same way a website is designed). We have recently changed the footer on our documents, saved and printed to ..pdf. Then I have had to make a small change to the footer, which is very time consuming to go through the many files we have. I would like to implement dynamic documents so our header...

links
hi i was wondering if anyone could help. when i sign into messenger i click on my inbox but the window will not open it just says connecting all the time.no error msg comes up. i also have this problem connecting to ebay through the nectar rewards site, very frustrating as i can collect points thanks in advance -- ZOE On Mon, 3 Dec 2007 14:31:01 -0800, madcow <madcow@discussions.microsoft.com> wrote: >hi i was wondering if anyone could help. >when i sign into messenger i click on my inbox but the window will not open >it just says connecting all the time.no error msg come...

Find a link to an external file
Hello, I'm working on a excel file constructed bij a person that doesn't work here any more. The problem with this excelfile is that there is a link to an external file wich excel can't find. I already tried to search for the filename he asks for in the equations and cels. But it doesnt result in any hits. How can I find this link so I can remove/change this cel. Does anyone has an idea? Tadashii. -- Tadashii ------------------------------------------------------------------------ Tadashii's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=239...

ExOleDB Permissions problem as linked server
I have Exchange 2000 server and SQL Server 2000 installed on the same box. I using the ExOLEDB data provider to set up Exchange as a linked server in SQL Server. A public folder is queried in a stored procedure using OpenQuery and a SQL Query against the Exchange folder. This all works fine, as long as the user is an administrator. If a non-admin attempts to use the stored procedure, the SQL Server returns the error "Could not create an instance of OLE DB provider 'exoledb.DataSource.1'.". I know that it can (as I can do it as admin), so it appears to be a permissions proble...

Pop-Up Subform not linking to Main Form
I have a subform - frmLawEnforcement - that is accessed on the main form - frmCorporateSecurity - by clicking on a command button from the main form. The two forms are linked by the CaseIDNumber field. If I place the subform as just an entry from with the main form, the information shows as linking by the CaseIDNumber. When I enter the information into the subform using the command button, the information does not link to the case number. I am not sure what I could be doing wrong. I am an intermediate Access user but am fairly limited on VBA. ABradley, It would help...

Refresh external data message
Hi I have a workbook that comprises of 2 worksheet, wk1 and wk2. Wk1 has detail information which feeds into a pivot table in wk2. I have one macro attached to the activate event on wk2 to refresh the pivot table. However, every time I open the workbook I get a message saying "This workbook contains queries to external data that refresh automatically......" "Enable automatic refresh" or "Disable automatic refresh". To the best of my knowledge I don't have any queries or links...can anyone tell me why this message is coming up and how to get rid of i...

find item in coloumn
Hi all I want to find a whole string in coulumn b how do I do that? Set c = ws.Cells.Find(ename, Null, Null, xlWhole) ' xlByColumns Set c = ws.Cells.Find(ename, "B3", Null, xlWhole) ' xlByColumns these fails totally The help does not explain anything Sonnich The macro recorder can be your friend Sub Macro7() ' ' Macro7 Macro ' Macro recorded 3/23/2010 by Donald B. Guillett ' ' Columns("B:B").Select Selection.find(What:="Person2", After:=ActiveCell, LookIn:=xlValues, _ Loo...

Setting Cell Links in Forms
Hello All, I am creating a spreadsheet with multiple check boxes and drop-downs, and wonder whether there is a way to globally set the forms to link to the cells which they populate - if the checkbox is in cell "G21", can I associate the value to cell G21 without manually going to the Format Control dialogue box? Doing so manually for each item is very (!) painful and time- consuming! Many Thanks, Alex If you're very careful with the placement, you could use a macro that assigns the linked cells: Option Explicit Sub testme() Dim myCBX As CheckBox Dim myDD As DropD...

editing while using "find"
After upgrading to XL2000 I can no longer edit cells without first closing the find window. You sure you didn't downgrade? xl2002 was the first version that had this ability. But you may want to try Jan Karel Pieterse's FlexFind: http://www.bmsltd.ie/MVP/ Kay wrote: > > After upgrading to XL2000 I can no longer edit cells > without first closing the find window. -- Dave Peterson ec35720@msn.com ...

Link from an Excel spreadsheet to a specific slide in PowerPoint
I can easily link from Excel to a PowerPoint file, but how can I make it go to a specific slide within that file/presentation? Thanks, Charlie in Virginia Beach Since PPt doesn't support bookmarks like Word, I doubt that you can. Perhaps another aproach, like saving a copy of the presentation as a Web file might get it done? |:>) "VAB Charlie" wrote: > I can easily link from Excel to a PowerPoint file, but how can I make it go > to a specific slide within that file/presentation? > > Thanks, > Charlie in Virginia Beach ...

where can I find a simple home budget work sheet?
I want to record all our home expenses on a daily basis to keep track of where the money is going. I am looking for a worksheet to accomplish this in a simple way. Thank you. "Jagadeep" <Jagadeep@discussions.microsoft.com> wrote in message news:92737A01-1804-42B0-8444-9B75F5D73B26@microsoft.com... > I want to record all our home expenses on a daily basis to keep track of > where the money is going. I am looking for a worksheet to accomplish this > in > a simple way. > Thank you. Try Office Online - plenty of Home Budget templates there. In f...

Where is the option in Windows Server Backup to add/remove external backup disks??
I'm running Windows Server Backup on my 2008 server. Everything works fine however I can't find the options for adding/removing a drive from the rotation schedule. For example say if I wanted to add a third external drive to the rotation schedule where are the options for this? Configure Backup -- Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist SBS2003 SBS2008 Support - www.SBITS.Biz Question or Second Opinion - www.PersonalITConsultant.com Free Trial Microsoft Online Services - www.Microsoft-Online-Services.co...

Business Portal 2.5 -- Linking 3 Web Parts
Hi, Can someone tell me if this is possible, I have been working on it and can't seem to get it to fly. I have my 1st web part that shows inventory master item information and a few fields off of the item card. This drives a 2nd web part that shows summary inventory information on that item by site. This works fine. What I want to do is tie a 3rd web part in that gives me detailed transaction information for that particular site (the 2nd web part). This 3rd web part works fine on it's own but shows all transactions for all sites for all items by default. I have tried ...

external data range a two way street?
I've sucessfully set up an external data range in excel that points to an access database query. It refreshes with no problem when making changes in Access. However I would like to be able to update cell values in excel & see the changes reflected in the Access db. I've tried playing around with the permissions but no matter what, any changes to data in excel get lost when the refresh button is hit. I'm sure I'm missing something . . . Thanks in advance. Hi bicyclops -- One way street. An external data range can suck data out of Access, SQL Server, Oracle, whateve...

How can I Copy WLM folders from external to "C" drive
Hard Drive Crashed and is now drive "I" as external. Reinstalled WLM on C Drive and it connected to my two email accounts, but did not bring all folders in. I still have a backup of my Outlook Express files from a month ago (prior to moving to WLM) that I wouldn't mind bringing in to replace the one email account. I also have a backup of my other email account. What would be the best way to handle this? You can go to File (ALT+F), Import Messages from WLM and point to the I drive folder that contains the old message store. Search for *.EML files to locate. Y...

import external data from password protected website?
How can I 'harvest' data from an html table when the user has to login to the website to get to the data? Also, it appears that 'import external data' just wants to dump the results into a spreadsheet, I want to pick out specific data and put them into the spreadsheet I've been maintaining. Can this be done via a macro? If you can point me to an example I'd appreciate it. -- Thanks in Advance, Jeff Hi Jeff, There is a password field for "get external data". Record a macro and add the field. Picking specific data to import depends on the "target m...

Macro to find and delete all FALSE statements
So i have a sheet filled with formulas and I have put IF,Then statements in them to return FALSE is I don't get the result I want. However, I need to erase all these FALSE results so they do not plot as zero on my chart. Anyway to create a macro? Thanks. You may not need a macro. If you formulas are of the type =IF(A1<10,FALSE,A1), select the range and use Edit | Replace to change FALSE to NA(). The NA() will show in cell as #N/A and will be ignored by the chart. best wishes -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "Woody13" &l...

External messages not coming in
I have an SMTP gateway set to received messages, scan them with Symantec Brightmail and then send it in to the Exchange server that has the users. All of a sudden yesterday messages stopped coming in. The outgoing messages are working fine. The SMTP server is a Windows 2003 enterprise and the Exchange server that catches the messages is a 5.5 server. I found an article on Microsoft Website regarding 8bitmime and I fixed that but it still does not work. Anyone has any suggestion. Thank you. On Tue, 9 Aug 2005 13:07:02 -0700, "h gregorian" <hgregorian@discussions.micr...

Mystery Threads
In this web app I’m working on there is this place that logs some information about Thread.CurrentThread. This logging is supposed to only happen on threads that the application spawns. The application assigns Thread.CurrentThread.Name a name and then later logs that name into a SQL Server table. But sometimes when we log the thread’s name it isn’t our assigned name. Instead it is “Thread-1” all the way up to “Thread-26”. By default Thread.CurrentThread.Name is null so we can’t figure out where these other threads are coming from. We can only reproduce this problem on a web se...

Linking then Sorting Objects of the Link
I am wondering if what I want to do is logical. (Excel 2002) I have a workbook with two worksheets. One of the sheets has a link to a row in the other. I created the link using right-click, then selecting "Hyperlink" and designating a defined name as the destination. (I designated the entire row as a defined name) Problem is, when I sort the latter sheet, the link still points to the defined name location, it does not seem to know to stay with the row that has the defined name I designated as the object of my link when it moves because of a sort. If I cut the row and paste it ...

Linking to Graphics
Is there a way in Excel 2003 to link column text to a .jpg photograph o my computer? I have to track inventory and would like to be able to se the object in question. If not, what options are available. I am ne to 2003 and have only used 97. Thanks -- scw121 ----------------------------------------------------------------------- scw1217's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=281 View this thread: http://www.excelforum.com/showthread.php?threadid=49770 Maybe you could just hyperlink to that file. =hyperlink("File:////c:/pictures/pict1.jpg&quo...