LinkBack URL
About LinkBacks
Hi, I have a cell that I would like to know if there are other cells in the same work book that reference to it's value. Is there any way to do that?
Thank you!
Hi, I have a cell that I would like to know if there are other cells in the same work book that reference to it's value. Is there any way to do that?
Thank you!
Hi and welcome to the board
Try Tools - Formula Auditing - Trace dependents
Yes, under the Tools dropdown menu "Formula Auditing". Trace dependents will show you what cells reference its value. If the reference is on another sheet, it shows a little spreadsheet icon. Double click on the dotted line to show the references. Hope that helped.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you guys, that really helped!
Clicking on the dotted line doesn't seem to work in Excel 2007. Is there another option?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks