Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / December 2005

Tip: Looking for answers? Try searching our database.

How do I Find links in worksheets - not in any formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RDFr - 14 Dec 2005 19:45 GMT
When I open the Excel 2000 file, I am asked about links I no longer want.  I
have tried to find these references in the worksheets so I can delete them
but have not been successful..
Ron Coderre - 14 Dec 2005 20:19 GMT
There are tools you can install, but try this first:

Select an empty section of a worksheet
Insert>Names>Paste>Paste List
Then check the references  for each name to see if it points to another
workbook.

If you want to change a reference or delete a name:
Insert>Names>Define
Select the name
then either delete it or change the reference.

If you don't see any linked workbooks...Repeat the paste list on each sheet
to discover if there are any sheet-level names that are a problem.

If that doesn't work...post back.

Does that help?

***********
Regards,
Ron

> When I open the Excel 2000 file, I am asked about links I no longer want.  I
> have tried to find these references in the worksheets so I can delete them
> but have not been successful..
Dave Peterson - 14 Dec 2005 21:17 GMT
When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

> When I open the Excel 2000 file, I am asked about links I no longer want.  I
> have tried to find these references in the worksheets so I can delete them
> but have not been successful..

Signature

Dave Peterson

William Horton - 14 Dec 2005 22:41 GMT
You can try the Excel menu path Edit / Go To and then choose the Special
option at the bottom left of the dialogue box.  Then choose the Formulas
option and click okay.  All the cells that contain formula's will be selected
(on active worksheet).  You can use your tab key to go through each cell and
view the formula bar for a link to another document.  It's not the best way
but the only way I know how.  Hopefully your file doesn't have too many
worksheets and/or formulas to go through.

Hope this helps.

Thanks,
Bill Horton

> When I open the Excel 2000 file, I am asked about links I no longer want.  I
> have tried to find these references in the worksheets so I can delete them
> but have not been successful..
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.