Colorado Spring
Registered User.
- Local time
- Today, 13:07
- Joined
- Dec 10, 2005
- Messages
- 36
Hello...
I have an excel spreadsheet that contains many links to documents saved on several different shared drives. This spreadsheet has many users and oftentimes these users save copies to their hard drives, or elsewhere.
Is there any way I can specify that all hyperlinks remain as absolute rather than reverting to relative once a user saves a copy in a different location? Is there any code I can include and, if so, where would it go?
Thanks in advance for your help ;>)
Karen
I have an excel spreadsheet that contains many links to documents saved on several different shared drives. This spreadsheet has many users and oftentimes these users save copies to their hard drives, or elsewhere.
Is there any way I can specify that all hyperlinks remain as absolute rather than reverting to relative once a user saves a copy in a different location? Is there any code I can include and, if so, where would it go?
Thanks in advance for your help ;>)
Karen