Copying Multiple Links at One Time

  • Thread starter Thread starter heelinva
  • Start date Start date
H

heelinva

Need someone's assistance to figure out how one can create multiple
links from files on a hard drive, into a spreadsheet with each file
link located in a separate cell.

Problem: I'm working over in Iraq and support an Iraqi group working
in a forensics area.

The Iraqi team I'm working with wants to produce an Excel spreadsheet
with links to specific files on their hard drive. Trouble is we have
almost 110,000 files to link. Is there a way to do this without
inputing each link individually?

Heelinva
 
Hi Heelinva,
The Iraqi team I'm working with wants to produce an Excel spreadsheet
with links to specific files on their hard drive. Trouble is we have
almost 110,000 files to link. Is there a way to do this without
inputing each link individually?
Click to expand...

This sounds like a monster workbook to me, designed for trouble.
I strongly doubt a file with so many links will be stable (if at all
possible).

Also, which such a huge amount of data, maybe Excel simply isn't the
right tool?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
 
Thanks for the heads up, it probably saved us a lot of work.

We will have to think of something else.

heelinv
 
You must log in or register to reply here.

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

how do I build linked workbooks 4
link comments to another excel file 2
multiple worksheets 1
change multiple links at once 1
Hyperlinks were lost 3
Link Excel to Access 3
Ruined hyperlinks... 1
Links won't update unless files are actually opened 9

Back
Top