LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default links in multiple workbooks

If you mean you're looking for formulas that are retrieving values from other
workbooks, you could use Edit|find and look through formulas for things like
".xls". But I find using Bill Manville's FindLink program much easier:
http://www.oaltd.co.uk/MVP/Default.htm

But if you meant you're looking for all the workbooks that have formulas that
link to a specific workbook (your workbook is "sending" the data), then I don't
think that there's a good way to find all those possible workbooks.

You could open each possible "receiving" workbook and look, but that only works
if you can at least limit the number of workbooks to search.

ChristyR wrote:

How can I find what cells are being linked in a source workbook?


--

Dave Peterson
 
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
how do i create table of contents links/pg for multiple workbooks JRoss Excel Worksheet Functions 1 June 3rd 07 09:14 PM
Links between workbooks British1942 Excel Worksheet Functions 3 January 11th 07 04:47 PM
Links to other Workbooks lost Mike Faulkner Excel Worksheet Functions 0 October 17th 05 09:01 AM
Links to other workbooks catalyst Excel Worksheet Functions 1 October 6th 05 08:34 PM
Links between workbooks Eddie Excel Discussion (Misc queries) 0 April 18th 05 03:21 PM


All times are GMT +1. The time now is 01:32 PM.

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

About Us

"It's about Microsoft Excel"