Hi,

I'm currently using Excel 2003 and create a variety of spreadsheets that
link between tabs and files. What inevitably happens is that I lose track in
a complex sheet of which cells link between files. I know you can go to Edit
-- Links to show the files that are linked and I know you can use the audit
function to find references within a sheet, but is there a way to find out
which cells in a sheet are linked to other files?

Thanks in advance!

Just use your find.

Get the file name you are looking for, then find this name and use Find All.
This will list all cells with that file name.

"Chris" wrote:

Hi,

I'm currently using Excel 2003 and create a variety of spreadsheets that
link between tabs and files. What inevitably happens is that I lose track in
a complex sheet of which cells link between files. I know you can go to Edit
-- Links to show the files that are linked and I know you can use the audit
function to find references within a sheet, but is there a way to find out
which cells in a sheet are linked to other files?

Thanks in advance!

Hi Sean,

Thank you thank you thank you!

"Sean Timmons" wrote:

Just use your find.

Get the file name you are looking for, then find this name and use Find All.
This will list all cells with that file name.

"Chris" wrote:

Hi,

I'm currently using Excel 2003 and create a variety of spreadsheets that
link between tabs and files. What inevitably happens is that I lose track in
a complex sheet of which cells link between files. I know you can go to Edit
-- Links to show the files that are linked and I know you can use the audit
function to find references within a sheet, but is there a way to find out
which cells in a sheet are linked to other files?

Thanks in advance!