Finding file references within cells
 

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!

Finding file references within cells
 

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!

Finding file references within cells
 

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!