Why do my hyperlinks in Excel change to a roaming folder?Excel automatic hyperlinksExcel 2007 hyperlinks to...
Why would space fleets be aligned?
How do you voice extended chords?
A starship is travelling at 0.9c and collides with a small rock. Will it leave a clean hole through, or will more happen?
Citing paywalled articles accessed via illegal web sharing
Is there any risk in sharing info about technologies and products we use with a supplier?
Why do we have to make "peinlich" start with a capital letter and also end with -s in this sentence?
How does Leonard in "Memento" remember reading and writing?
Why do neural networks need so many training examples to perform?
Has Britain negotiated with any other countries outside the EU in preparation for the exit?
False written accusations not made public - is there law to cover this?
Why don't key signatures indicate the tonic?
TikZ graph edges not drawn nicely
Why did the villain in the first Men in Black movie care about Earth's Cockroaches?
Should I reinstall Linux when changing the laptop's CPU?
How can I play a serial killer in a party of good PCs?
Do "fields" always combine by addition?
What would you call a real market that is close to perfect competition?
Is this ordinary workplace experiences for a job in Software Engineering?
After checking in online, how do I know whether I need to go show my passport at airport check-in?
Globe trotting Grandpa. Where is he going next?
How to make ice magic work from a scientific point of view?
Which communication protocol is used in AdLib sound card?
Play Zip, Zap, Zop
Does Skippy chunky peanut butter contain trans fat?
Why do my hyperlinks in Excel change to a roaming folder?
Excel automatic hyperlinksExcel 2007 hyperlinks to other workbooks not redirecting properlyCopying Excel Spreadsheet with Absolute Hyperlinks to Documents (change to relative?)delimiting text in Excel messes up hyperlinksWhy have the hyperlinks in Excel 2013 stopped working?Placeholders for filename characters in Excel hyperlinksExcel - Change hyperlinksMoving Excel document breaks hyperlinks URL formatExcel Hyperlinks against Outlook Hyperlinks?Export Excel File with in-file hyperlinks into a PDF
I have created some hyperlinks in a workbook,
Using CTRL + K.
They worked as intended and opened the new workbooks when clicked.
A few hours later, the links have changed and they now link to a roaming folder ?
Orginal link was:
\uk.finning.comdataGroupHeavy ConstructionNew SalesEF2C DashboardDemand & SupplySurplus Stock.xlsm
New link is:
C:Users8997AppDataRoamingMicrosoftExcelDemand & SupplySurplus Stock.xlsm
What is the cause of this ? and will other users clicking the link be able to get to the original document ?
microsoft-excel hyperlink
asked Apr 26 '18 at 15:39
PeterHPeterH
3,51732548
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have created some hyperlinks in a workbook,
Using CTRL + K.
They worked as intended and opened the new workbooks when clicked.
A few hours later, the links have changed and they now link to a roaming folder ?
Orginal link was:
\uk.finning.comdataGroupHeavy ConstructionNew SalesEF2C DashboardDemand & SupplySurplus Stock.xlsm
New link is:
C:Users8997AppDataRoamingMicrosoftExcelDemand & SupplySurplus Stock.xlsm
What is the cause of this ? and will other users clicking the link be able to get to the original document ?
microsoft-excel hyperlink
asked Apr 26 '18 at 15:39
PeterHPeterH
3,51732548
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have created some hyperlinks in a workbook,
Using CTRL + K.
They worked as intended and opened the new workbooks when clicked.
A few hours later, the links have changed and they now link to a roaming folder ?
Orginal link was:
\uk.finning.comdataGroupHeavy ConstructionNew SalesEF2C DashboardDemand & SupplySurplus Stock.xlsm
New link is:
C:Users8997AppDataRoamingMicrosoftExcelDemand & SupplySurplus Stock.xlsm
What is the cause of this ? and will other users clicking the link be able to get to the original document ?
microsoft-excel hyperlink
asked Apr 26 '18 at 15:39
PeterHPeterH
3,51732548
I have created some hyperlinks in a workbook,
Using CTRL + K.
They worked as intended and opened the new workbooks when clicked.
A few hours later, the links have changed and they now link to a roaming folder ?
Orginal link was:
\uk.finning.comdataGroupHeavy ConstructionNew SalesEF2C DashboardDemand & SupplySurplus Stock.xlsm
New link is:
C:Users8997AppDataRoamingMicrosoftExcelDemand & SupplySurplus Stock.xlsm
What is the cause of this ? and will other users clicking the link be able to get to the original document ?
microsoft-excel hyperlink
microsoft-excel hyperlink
asked Apr 26 '18 at 15:39
PeterHPeterH
3,51732548
asked Apr 26 '18 at 15:39
PeterHPeterH
3,51732548
asked Apr 26 '18 at 15:39
PeterHPeterH
3,51732548
asked Apr 26 '18 at 15:39
PeterHPeterH
3,51732548
asked Apr 26 '18 at 15:39
PeterHPeterH
3,51732548
3,51732548
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
There is no way to stop Excel from doing this unless you do not save over the original.
From Microsoft KB Article:
There are several circumstances in which links between files can be inadvertently made to point to erroneous locations. The following are two of the most common scenarios.
Scenario 1:
- You map a drive under the root of a share. For example, you map drive Z to ServerShareFolder1.
- You create links to a workbook that is stored at the mapped location after you open the file through that mapped drive.
- You open the file by a UNC path.
As a consequence the link will be broken.
If you close the file without saving it, the links will not be changed. However, if you save the file before you close it, you will save the links with the current broken path. The folders between the root of the share and the mapped folder will be left out of the path. In the example above, the link would change to ServerFolder1. In other words, the Share name is eliminated from the path.
Scenario 2:
- You map a drive under the root of a share. For example, you map drive Z to ServerShareFolder1.
- You open the file by a UNC path or a mapped drive mapped to a different folder on the share, such as ServerShareFolder2.
- As a consequence, the link will be broken.
If you close the file without saving it, the links will not be changed. However, if you save the file before you close it, you will save the links with the current broken path. The folders between the root of the share and the mapped folder will be left out of the path. In the example above, the link would change to ServerFolder1.
Microsoft Knowledge Base article regarding this:
Description of link management and storage in Excel
answered Apr 26 '18 at 16:02
Austin RossAustin Ross
12
Welcome to Super User and thank you for your answer. Is there anything you can quote from the KB article in your answer (by [editing it in][(superuser.com/posts/1317475/edit)) ?
– bertieb
Apr 26 '18 at 16:04
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1317466%2fwhy-do-my-hyperlinks-in-excel-change-to-a-roaming-folder%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
There is no way to stop Excel from doing this unless you do not save over the original.
From Microsoft KB Article:
There are several circumstances in which links between files can be inadvertently made to point to erroneous locations. The following are two of the most common scenarios.
Scenario 1:
- You map a drive under the root of a share. For example, you map drive Z to ServerShareFolder1.
- You create links to a workbook that is stored at the mapped location after you open the file through that mapped drive.
- You open the file by a UNC path.
As a consequence the link will be broken.
If you close the file without saving it, the links will not be changed. However, if you save the file before you close it, you will save the links with the current broken path. The folders between the root of the share and the mapped folder will be left out of the path. In the example above, the link would change to ServerFolder1. In other words, the Share name is eliminated from the path.
Scenario 2:
- You map a drive under the root of a share. For example, you map drive Z to ServerShareFolder1.
- You open the file by a UNC path or a mapped drive mapped to a different folder on the share, such as ServerShareFolder2.
- As a consequence, the link will be broken.
If you close the file without saving it, the links will not be changed. However, if you save the file before you close it, you will save the links with the current broken path. The folders between the root of the share and the mapped folder will be left out of the path. In the example above, the link would change to ServerFolder1.
Microsoft Knowledge Base article regarding this:
Description of link management and storage in Excel
answered Apr 26 '18 at 16:02
Austin RossAustin Ross
12
Welcome to Super User and thank you for your answer. Is there anything you can quote from the KB article in your answer (by [editing it in][(superuser.com/posts/1317475/edit)) ?
– bertieb
Apr 26 '18 at 16:04
add a comment |
There is no way to stop Excel from doing this unless you do not save over the original.
From Microsoft KB Article:
There are several circumstances in which links between files can be inadvertently made to point to erroneous locations. The following are two of the most common scenarios.
Scenario 1:
- You map a drive under the root of a share. For example, you map drive Z to ServerShareFolder1.
- You create links to a workbook that is stored at the mapped location after you open the file through that mapped drive.
- You open the file by a UNC path.
As a consequence the link will be broken.
If you close the file without saving it, the links will not be changed. However, if you save the file before you close it, you will save the links with the current broken path. The folders between the root of the share and the mapped folder will be left out of the path. In the example above, the link would change to ServerFolder1. In other words, the Share name is eliminated from the path.
Scenario 2:
- You map a drive under the root of a share. For example, you map drive Z to ServerShareFolder1.
- You open the file by a UNC path or a mapped drive mapped to a different folder on the share, such as ServerShareFolder2.
- As a consequence, the link will be broken.
If you close the file without saving it, the links will not be changed. However, if you save the file before you close it, you will save the links with the current broken path. The folders between the root of the share and the mapped folder will be left out of the path. In the example above, the link would change to ServerFolder1.
Microsoft Knowledge Base article regarding this:
Description of link management and storage in Excel
answered Apr 26 '18 at 16:02
Austin RossAustin Ross
12
Welcome to Super User and thank you for your answer. Is there anything you can quote from the KB article in your answer (by [editing it in][(superuser.com/posts/1317475/edit)) ?
– bertieb
Apr 26 '18 at 16:04
add a comment |
There is no way to stop Excel from doing this unless you do not save over the original.
From Microsoft KB Article:
There are several circumstances in which links between files can be inadvertently made to point to erroneous locations. The following are two of the most common scenarios.
Scenario 1:
- You map a drive under the root of a share. For example, you map drive Z to ServerShareFolder1.
- You create links to a workbook that is stored at the mapped location after you open the file through that mapped drive.
- You open the file by a UNC path.
As a consequence the link will be broken.
If you close the file without saving it, the links will not be changed. However, if you save the file before you close it, you will save the links with the current broken path. The folders between the root of the share and the mapped folder will be left out of the path. In the example above, the link would change to ServerFolder1. In other words, the Share name is eliminated from the path.
Scenario 2:
- You map a drive under the root of a share. For example, you map drive Z to ServerShareFolder1.
- You open the file by a UNC path or a mapped drive mapped to a different folder on the share, such as ServerShareFolder2.
- As a consequence, the link will be broken.
If you close the file without saving it, the links will not be changed. However, if you save the file before you close it, you will save the links with the current broken path. The folders between the root of the share and the mapped folder will be left out of the path. In the example above, the link would change to ServerFolder1.
Microsoft Knowledge Base article regarding this:
Description of link management and storage in Excel
answered Apr 26 '18 at 16:02
Austin RossAustin Ross
12
There is no way to stop Excel from doing this unless you do not save over the original.
From Microsoft KB Article:
There are several circumstances in which links between files can be inadvertently made to point to erroneous locations. The following are two of the most common scenarios.
Scenario 1:
- You map a drive under the root of a share. For example, you map drive Z to ServerShareFolder1.
- You create links to a workbook that is stored at the mapped location after you open the file through that mapped drive.
- You open the file by a UNC path.
As a consequence the link will be broken.
If you close the file without saving it, the links will not be changed. However, if you save the file before you close it, you will save the links with the current broken path. The folders between the root of the share and the mapped folder will be left out of the path. In the example above, the link would change to ServerFolder1. In other words, the Share name is eliminated from the path.
Scenario 2:
- You map a drive under the root of a share. For example, you map drive Z to ServerShareFolder1.
- You open the file by a UNC path or a mapped drive mapped to a different folder on the share, such as ServerShareFolder2.
- As a consequence, the link will be broken.
If you close the file without saving it, the links will not be changed. However, if you save the file before you close it, you will save the links with the current broken path. The folders between the root of the share and the mapped folder will be left out of the path. In the example above, the link would change to ServerFolder1.
Microsoft Knowledge Base article regarding this:
Description of link management and storage in Excel
answered Apr 26 '18 at 16:02
Austin RossAustin Ross
12
edited Apr 26 '18 at 16:25
answered Apr 26 '18 at 16:02
Austin RossAustin Ross
12
answered Apr 26 '18 at 16:02
Austin RossAustin Ross
12
answered Apr 26 '18 at 16:02
Austin RossAustin Ross
12
12
Welcome to Super User and thank you for your answer. Is there anything you can quote from the KB article in your answer (by [editing it in][(superuser.com/posts/1317475/edit)) ?
– bertieb
Apr 26 '18 at 16:04
add a comment |
Welcome to Super User and thank you for your answer. Is there anything you can quote from the KB article in your answer (by [editing it in][(superuser.com/posts/1317475/edit)) ?
– bertieb
Apr 26 '18 at 16:04
Welcome to Super User and thank you for your answer. Is there anything you can quote from the KB article in your answer (by [editing it in][(superuser.com/posts/1317475/edit)) ?
– bertieb
Apr 26 '18 at 16:04
Welcome to Super User and thank you for your answer. Is there anything you can quote from the KB article in your answer (by [editing it in][(superuser.com/posts/1317475/edit)) ?
– bertieb
Apr 26 '18 at 16:04
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1317466%2fwhy-do-my-hyperlinks-in-excel-change-to-a-roaming-folder%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
