Copying files w/ lots of links

  • Thread starter Thread starter gregg
  • Start date Start date
G

gregg

I have created a large spreadsheet with tons of blueprints linked to it.
Now I want to send this file to my customer. The file is over 10 megs so I
burned a copy. My problem is I have all the files on the disc, but the links
don't work . Are the links looking for the source on my hard drive? How can
I get the links to respond to the files that are on the customer disc.
I can jus redo the links if that's what it takes.
Regards,
 
Are you or your customer trying to work directly *from the disc*?

XL likes hard drives.
Try copying, or telling your customer to copy the disc to the hard drive.

That *may* bring up another problem that sometimes pops up when using discs
.... "Read Only".
In that case, use *Windows Explorer* and navigate to the file in question,
right click on the file and choose "Properties", and *uncheck* it in that
window.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have created a large spreadsheet with tons of blueprints linked to it.
Now I want to send this file to my customer. The file is over 10 megs so I
burned a copy. My problem is I have all the files on the disc, but the links
don't work . Are the links looking for the source on my hard drive? How can
I get the links to respond to the files that are on the customer disc.
I can jus redo the links if that's what it takes.
Regards,
 
I've always had better luck when all the files are in the same folder.

Any chance you can copy into the same folder?

If that didn't work (check a link formula to see the path), then try opening all
the linked workbooks (not sure what tons represents), then save a copy of each
to a common folder.

You may want to test it with a few workbooks to see if this works. (It seemed
to work ok for me with just a couple.)
 
Thanks for the help, I put everything in one file and it worked like a hose.
Perfect.
 
Back
Top