Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 7th 06, 02:26 AM posted to microsoft.public.excel.misc
 
Posts: n/a
Default Trace Dependent Cells of the Linked Files

How do I identify the cells in the receiving file for a given linking file?
(For each linking file, I want to identified the cells that are affected by
the linkage)

Thanks,

  #2   Report Post  
Old March 7th 06, 02:53 AM posted to microsoft.public.excel.misc
davesexcel
 
Posts: n/a
Default Trace Dependent Cells of the Linked Files


I am not to sure what you mean,
If you pressed the two keys
ctrl & `(thats the key to the left of the 1 at the top of your key
board) all the formulas will show on screen or are you actually looking
for links to your workbook, in that case you would best to download
findlinks add-in just type findlinks-addin in the search bar and you
will have no problem finding it.


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519586



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
Linked Files Sina Excel Discussion (Misc queries) 0 December 25th 05 09:52 AM
How to save values only from linked Excel files? jmadam39 Excel Discussion (Misc queries) 3 November 30th 05 06:27 PM
Linked cells show wrong number Guy Links and Linking in Excel 3 February 22nd 05 06:46 PM
Two spreadsheets linked - moving cells Adam Excel Discussion (Misc queries) 1 January 4th 05 01:59 PM
Excel '02: does it allow source files (linked cells) to be opened. RAS Excel Discussion (Misc queries) 1 December 9th 04 12:49 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017