ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   email excel document with hyperlinks to mutliple documents (https://www.excelbanter.com/excel-discussion-misc-queries/102850-email-excel-document-hyperlinks-mutliple-documents.html)

angiey

email excel document with hyperlinks to mutliple documents
 
I need to send several people an excel document that hyperlinks to many other
documents. The recipients need to get all the information from the other
documents. How can I make this happen?

Dave Peterson

email excel document with hyperlinks to mutliple documents
 
Make sure the hyperlinks point files in a common location--like a network
drive. I'd use the UNC path so that I wouldn't have to worry about users having
different mapped drives.



angiey wrote:

I need to send several people an excel document that hyperlinks to many other
documents. The recipients need to get all the information from the other
documents. How can I make this happen?


--

Dave Peterson

angiey

email excel document with hyperlinks to mutliple documents
 
Dave, thanks€¦ let me give you a little more info.
A colleague from Castle Rock (where the pc with files is) is in Orlando
(with his laptop). I am in Tennessee. He needs to send the excel document
to people in three other states for a board meeting. His excel document is
already formatted with hyperlinks to the documents back home. How can he
give all these people access to the data?


"Dave Peterson" wrote:

Make sure the hyperlinks point files in a common location--like a network
drive. I'd use the UNC path so that I wouldn't have to worry about users having
different mapped drives.



angiey wrote:

I need to send several people an excel document that hyperlinks to many other
documents. The recipients need to get all the information from the other
documents. How can I make this happen?


--

Dave Peterson


Dave Peterson

email excel document with hyperlinks to mutliple documents
 
Untested.

I think if you keep all the files in the same folder and tell each user to do
the same, it'll work.

But test it before you trust it.

angiey wrote:

Dave, thanks€¦ let me give you a little more info.
A colleague from Castle Rock (where the pc with files is) is in Orlando
(with his laptop). I am in Tennessee. He needs to send the excel document
to people in three other states for a board meeting. His excel document is
already formatted with hyperlinks to the documents back home. How can he
give all these people access to the data?


"Dave Peterson" wrote:

Make sure the hyperlinks point files in a common location--like a network
drive. I'd use the UNC path so that I wouldn't have to worry about users having
different mapped drives.



angiey wrote:

I need to send several people an excel document that hyperlinks to many other
documents. The recipients need to get all the information from the other
documents. How can I make this happen?


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 03:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com