[Firemanmsmith]

I am looking for a way to easily transfer worksheet + pictures to several computers. I have the pics hyperlinked to "My Pictures" on my computer. How can I save them so that I will be able to load the worksheet on multiple computers without breaking the link? I have not ladded many pics yet so I could start over if need be. I will eventually have as many as 5000 pictures linked to this worksheet. Thanks in advance......Mitch

[Bill Manville]

Firemanmsmith wrote:
I have the pics hyperlinked to "My Pictures" on my
computer. How can I save them so that I will be able to load the
worksheet on multiple computers without breaking the link?


Are all the computers that might open the worksheet networked together?
- If not you would have to distribute the pictures with the worksheet
and relative links would be fine - so just have the pictures in the
same folder as the worksheet.
- If so then put the pictures on a server on the network, and set the
hyperlink base of your workbook (in File Properties Summary) to a
non-existent folder (e.g. \\Junk\Folder ) and the links will be created
as absolute.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

[Firemanmsmith]

Originally Posted by Bill Manville

Firemanmsmith wrote:
I have the pics hyperlinked to "My Pictures" on my
computer. How can I save them so that I will be able to load the
worksheet on multiple computers without breaking the link?


Are all the computers that might open the worksheet networked together?
- If not you would have to distribute the pictures with the worksheet
and relative links would be fine - so just have the pictures in the
same folder as the worksheet.
- If so then put the pictures on a server on the network, and set the
hyperlink base of your workbook (in File Properties Summary) to a
non-existent folder (e.g. \\Junk\Folder ) and the links will be created
as absolute.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

The computers are not networked at this time. I am told that they will be in the near future, but that could mean a couple years before they are. Most of the computers that I will be installing on are laptops on our fire trucks and there is not a reliable wireless connection throughout the city.
I had started hyperlnking the pics from files on my comp. and realized that the link would be broken when I installed the sheet on a different computer. I was not sure about the ability to save several thousand pics to a sheet, and I am not sure how to save them to a file that the sheet will recognize (because of the location change when moved). Thanks for the help.....Mitch

[Bill Manville]

I would recommend you copy the files (worksheet and pictures) to the
same folders on each machine. That way there should be no problems.

Depending on your version of Excel the hyperlinks may be saved as
relative links in which case having all the pictures in or below the
folder containing the workbook should work and the top folder can then
be different on the different machines.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup