identify references to linked information

L

LBA

I moved excel books three years and older to an archive folder. However,
some excel books in current use contain information linked to archived books.
Now excel cannot automatically find the source worksheets for the linked
information. I have to manually point it to the archive folder which is time
consuming. I would like to display the linked information references in the
current books so that I can update their source addresses.
I use Windows 2000, service pack 4
 

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

Working on birthday "book" for my wife and having layout/editing trouble 0
Sorting Linked Data Between Sheets 3
transfering information 0
Need to change cell reference of an already linked Excel data set 0
Moving linked files from one server to anoter one 3
Link to another workbook path issue 1
How to compare and combine information from 2 different excelworksheets (VLOOKUP ? Pivot Table ?) 1
Links Between Folders 4

Top