Hi,

Select the cell then

Tools|Formula Auditing
Click on trace precedents or Dependents

Mike

"liz" wrote:

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