#1   Report Post  
JJC
 
Posts: n/a
Default Linked cells


I have a number of cells within an Excel file that are linked to cells
in other Excel files. Is there a way to identify which cells in a file
are linked to other files?


--
JJC
------------------------------------------------------------------------
JJC's Profile: http://www.excelforum.com/member.php...o&userid=20027
View this thread: http://www.excelforum.com/showthread...hreadid=346119

  #2   Report Post  
BobT
 
Posts: n/a
Default

Here's the brute force method:

If you go to Edit/Links you will see the list of external
files. You can do a find for these filenames in your
worksheets.

If you do a find all, then hit "ctrl + A" to select all,
then escape, all the cells with links to that workbook
will be highlighted. You can then color code these cells.

Of course you have to do the same for your other
worksheets, and start over for the next file if you have
links to more than one file. At least you can use a
different color code for each file.


-----Original Message-----

I have a number of cells within an Excel file that are

linked to cells
in other Excel files. Is there a way to identify which

cells in a file
are linked to other files?


--
JJC
----------------------------------------------------------

--------------
JJC's Profile: http://www.excelforum.com/member.php?

action=getinfo&userid=20027
View this thread:

http://www.excelforum.com/showthread...hreadid=346119

.

  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

JJC

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, 16 Feb 2005 15:21:44 -0600, JJC
wrote:


I have a number of cells within an Excel file that are linked to cells
in other Excel files. Is there a way to identify which cells in a file
are linked to other files?


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
Update linked cells within a workbook??? Chance224 Links and Linking in Excel 4 January 21st 05 06:33 PM
Two spreadsheets linked - moving cells Adam Excel Discussion (Misc queries) 1 January 4th 05 12:59 PM
Sorting mixed up linked cells in a workbook? Destiny Excel Worksheet Functions 2 November 20th 04 03:17 AM
How to stop #REF! on linked cells in complex spreadsheets Formann Excel Worksheet Functions 0 November 18th 04 12:34 PM
listing linked cells tyetman Excel Worksheet Functions 1 November 2nd 04 12:57 PM


All times are GMT +1. The time now is 02:32 AM.

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

About Us

"It's about Microsoft Excel"