is there a way to show what each cell links to?

L

liz

i have created a massive document containing 15 spreadsheets, some cells are
linked on multiple sheets and i wanted to know if there was a way to click on
the cell and it would show what other cells have it linked in their formula
 
M

Mike H

Hi,

Select the cell then

Tools|Formula Auditing
Click on trace precedents or Dependents

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change multiple links at once 1
Way 4
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
#N/A In Cells 7
Linked cells - why '0' when blank? 3
error with countif formula on when adding linked spreadsheets 0
XL2000 Links Between Workbooks 2

Top