Home News Forum Articles
  Welcome back Join CF
You are here You are here: Home | Forum | Excel emailed spreadsheet loses hyperlinks

You are currently viewing our boards as a guest which gives you limited access to view most of the discussions, articles and other free features. By joining our Virgin Media community you will have full access to all discussions, be able to view and post threads, communicate privately with other members (PM), respond to polls, upload your own images/photos, and access many other special features. Registration is fast, simple and absolutely free so please join our community today.


Welcome to Cable Forum
Go Back   Cable Forum > Computers & IT > General IT Discussion

Excel emailed spreadsheet loses hyperlinks
Reply
 
Thread Tools
Old 06-09-2019, 10:42   #1
Mike
cf.mega poster
 
Join Date: Jan 2004
Age: 61
Posts: 2,242
Mike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful one
Excel emailed spreadsheet loses hyperlinks

Hi all

My spreadsheet has some hyperlinks.... linked to documents on my local works drive (P)...when I email sheet to other people at work the links don't work although they have access to the same works drive...... hovering over the links on other peoples machine it appears the hyperlink have changed to their local drive(C) rather than the main works drive(P)...and then don't work.

Any ideas on what the issue is and how it fix

Many thanks for your time

Regards

Mike
Mike is offline   Reply With Quote
Advertisement
Old 08-09-2019, 20:47   #2
idi banashapan
step on my trip
 
idi banashapan's Avatar
 
Join Date: Jul 2003
Posts: 3,714
idi banashapan has a nice shiny star
idi banashapan has a nice shiny staridi banashapan has a nice shiny staridi banashapan has a nice shiny staridi banashapan has a nice shiny staridi banashapan has a nice shiny staridi banashapan has a nice shiny staridi banashapan has a nice shiny staridi banashapan has a nice shiny staridi banashapan has a nice shiny staridi banashapan has a nice shiny star
Re: Excel emailed spreadsheet loses hyperlinks

Try using the full UNC path rather than the drive mapping for the links:

\\ServerName\ShareName\FolderName\FileName.xlsx
__________________
If one does not understand a person, one tends to regard him as a fool
idi banashapan is offline   Reply With Quote
Old 09-09-2019, 17:47   #3
Taf
cf.mega poster
 
Taf's Avatar
 
Join Date: Jun 2003
Location: Kairdiff-by-the-sea
Age: 68
Services: TVXL BBXL Superhub 2ac (wired) 1Tb Tivo
Posts: 9,785
Taf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny star
Taf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny star
Re: Excel emailed spreadsheet loses hyperlinks

It's a common problem when writing HTML. You have to specify the source path correctly.
Taf is offline   Reply With Quote
Old 17-09-2019, 20:34   #4
timbow
Inactive
 
Join Date: Sep 2019
Location: Haywards Heath
Services: Shy
Posts: 2
timbow is an unknown quantity at this point
Re: Excel emailed spreadsheet loses hyperlinks

This article may help

https://www.stellarinfo.com/blog/mak...links-working/
timbow is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 16:53.


Server: osmium.zmnt.uk
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.