Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 154
Default TRACKING CORRECTLY LINKED CELLS!


In my excel workbook, cells in SheetA link to cells in SheetB.These
links are many.
The problem is that occasionally, I find that some of the cells in
SheetB are linked to the wrong cells in SheetA.

Question- I need a way to check that the cells in SheetB are linked to
the right cells in SheetA. I tried using Ctrl+~ but because the linked
cells are too many and the formulas are sometimes too long, manually
verifying the cell links is an eye-strainer. Are there any better or
easier ways? Any help would be greatly apppreciated. Thanks.

Jay Dean

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
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
Tracking linked file usage SwordAngel Excel Discussion (Misc queries) 1 March 2nd 09 11:39 AM
Sorting non-linked cells in a linked worksheet Gary Excel Discussion (Misc queries) 1 October 25th 08 03:38 AM
Tracking Linked Cells vpoincelot Excel Discussion (Misc queries) 1 December 6th 06 05:51 PM
tracking linked cells vpoincelot Excel Worksheet Functions 0 December 6th 06 12:06 AM
Linked Cells Staying With Cells Once Linked Workbook Update. [email protected] Excel Worksheet Functions 0 June 6th 06 09:32 AM


All times are GMT +1. The time now is 11:46 AM.

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

About Us

"It's about Microsoft Excel"