Need to transfer sheet + pictures to multiple computers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Firemanmsmith - 19 Mar 2008 22:02 GMT

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

Signature

Firemanmsmith

Reply to this Message

Bill Manville - 21 Mar 2008 00:13 GMT

> 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

Reply to this Message

Firemanmsmith - 21 Mar 2008 10:30 GMT

Bill Manville;642285 Wrote:

> Firemanmsmith wrote:-
> > I have the pics hyperlinked to "My Pictures" on my
[quoted text clipped - 16 lines]
> 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

Signature

Firemanmsmith

Reply to this Message

Bill Manville - 21 Mar 2008 19:15 GMT

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

Reply to this Message

Rate this thread: