Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 14th 05, 08:45 PM posted to microsoft.public.excel.worksheet.functions
RDFr
 
Posts: n/a
Default How do I Find links in worksheets - not in any formula

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..

  #2   Report Post  
Old December 14th 05, 09:19 PM posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default How do I Find links in worksheets - not in any formula

There are tools you can install, but try this first:

Select an empty section of a worksheet
InsertNamesPastePaste 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:
InsertNamesDefine
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


"RDFr" wrote:

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..

  #3   Report Post  
Old December 14th 05, 10:17 PM posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default How do I Find links in worksheets - not in any formula

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

RDFr wrote:

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
  #4   Report Post  
Old December 14th 05, 11:41 PM posted to microsoft.public.excel.worksheet.functions
William Horton
 
Posts: n/a
Default How do I Find links in worksheets - not in any formula

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

"RDFr" wrote:

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..



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
FIND FORMULA SIMILAR TO VLOOKUP FOR NON-ASCENDING VALUES Kir Excel Worksheet Functions 2 November 10th 05 10:39 PM
ADD A RETURN BUTTON WHEN GOING TO FORMULA REFERENCE LINKS KJSacramento New Users to Excel 0 November 8th 05 05:12 PM
find formula between worksheets aledger Excel Discussion (Misc queries) 0 October 5th 05 02:59 AM
Help! Formula to find the address of particular value in sheet xcelion Excel Worksheet Functions 2 July 13th 05 12:41 PM
Find Matching Records in Two Worksheets kittybat Excel Discussion (Misc queries) 2 April 5th 05 06:51 PM


All times are GMT +1. The time now is 08:07 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017