Excel changing UNC paths in shared workbook Announcing the arrival of Valued Associate #679:...
Caught masturbating at work
Simple Line in LaTeX Help!
Why datecode is SO IMPORTANT to chip manufacturers?
Why is it faster to reheat something than it is to cook it?
How do living politicians protect their readily obtainable signatures from misuse?
Simple HTTP Server
My mentor says to set image to Fine instead of RAW — how is this different from JPG?
Did any compiler fully use 80-bit floating point?
Flight departed from the gate 5 min before scheduled departure time. Refund options
Special flights
Why are vacuum tubes still used in amateur radios?
How much damage would a cupful of neutron star matter do to the Earth?
Weaponising the Grasp-at-a-Distance spell
Central Vacuuming: Is it worth it, and how does it compare to normal vacuuming?
Why is the change of basis formula counter-intuitive? [See details]
What order were files/directories output in dir?
Is it possible for SQL statements to execute concurrently within a single session in SQL Server?
How does light 'choose' between wave and particle behaviour?
How to change the tick of the color bar legend to black
How many time has Arya actually used Needle?
As a dual citizen, my US passport will expire one day after traveling to the US. Will this work?
Random body shuffle every night—can we still function?
After Sam didn't return home in the end, were he and Al still friends?
Resize vertical bars (absolute-value symbols)
Excel changing UNC paths in shared workbook
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)Importing external worksheet data into Excel 2010 workbookIs data validation incompatible between Excel 2007 and Excel 2010?Copying worksheets in ExcelExcel 2010 shared workbook - image buttons disabledHow to make Excel use relative paths in external workbook linksLink with UNC path is broken after copying cells from Excel 2010 to Word 2010Large workbook slow to open, but fast when split into two linked workbooks. Why?Software: Excel VBA Not Populating Default File Name in SaveAs Dialog BoxStatic UNC “shortcut” to network folder?Excel Reverting from Shared drive to UNC path and then losing links
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
Excel documents stored on network drive, for example, \networkdataExcelShared
Data workbook.xls contains tables with data entered into.
Report.xls contains UNC paths pointing to \networkdataexcelsharedworkbook.xls
Users enter data into data workbook.xls, and then see this reflected in report.xls- one workbook pulls data from the other.
One machine is giving issues. If this machine opens, edits and saves these documents, it changes the paths to reflect the local machine!
The machine has the path mapped as a drive, eg H: (\networkdataexcelshared), so opening a file from here will give the path H:data workbook.xls. I came across this article online which seems to talk about a similar issue-
The Knowledge Base article indicates that if a workbook is opened from a mapped drive, and the UNC >refers to that same drive, the UNC in the link is updated to the mapped drive designation.
Thinking that I had struck gold, I compared the set up (mapped drives, shortcuts etc) to another user's machine to identify a difference. The other machine has no issues but has the network location mapped exactly the same, as the same drive letter.
As a result this machine cannot be used to edit these shared workbooks, as if it saves it, it no longer points to the correct workbook on the network (eg it won't point to \networkdataexcelshared, but instread will refer to the location machine)
Any ideas?
microsoft-excel microsoft-excel-2010 network-shares
edited Jan 14 '15 at 11:29
Dave
23.4k84463
asked Jan 14 '15 at 11:24
RASBRASB
112515
bumped to the homepage by Community♦ 4 hours 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 |
Excel documents stored on network drive, for example, \networkdataExcelShared
Data workbook.xls contains tables with data entered into.
Report.xls contains UNC paths pointing to \networkdataexcelsharedworkbook.xls
Users enter data into data workbook.xls, and then see this reflected in report.xls- one workbook pulls data from the other.
One machine is giving issues. If this machine opens, edits and saves these documents, it changes the paths to reflect the local machine!
The machine has the path mapped as a drive, eg H: (\networkdataexcelshared), so opening a file from here will give the path H:data workbook.xls. I came across this article online which seems to talk about a similar issue-
The Knowledge Base article indicates that if a workbook is opened from a mapped drive, and the UNC >refers to that same drive, the UNC in the link is updated to the mapped drive designation.
Thinking that I had struck gold, I compared the set up (mapped drives, shortcuts etc) to another user's machine to identify a difference. The other machine has no issues but has the network location mapped exactly the same, as the same drive letter.
As a result this machine cannot be used to edit these shared workbooks, as if it saves it, it no longer points to the correct workbook on the network (eg it won't point to \networkdataexcelshared, but instread will refer to the location machine)
Any ideas?
microsoft-excel microsoft-excel-2010 network-shares
edited Jan 14 '15 at 11:29
Dave
23.4k84463
asked Jan 14 '15 at 11:24
RASBRASB
112515
bumped to the homepage by Community♦ 4 hours 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 |
Excel documents stored on network drive, for example, \networkdataExcelShared
Data workbook.xls contains tables with data entered into.
Report.xls contains UNC paths pointing to \networkdataexcelsharedworkbook.xls
Users enter data into data workbook.xls, and then see this reflected in report.xls- one workbook pulls data from the other.
One machine is giving issues. If this machine opens, edits and saves these documents, it changes the paths to reflect the local machine!
The machine has the path mapped as a drive, eg H: (\networkdataexcelshared), so opening a file from here will give the path H:data workbook.xls. I came across this article online which seems to talk about a similar issue-
The Knowledge Base article indicates that if a workbook is opened from a mapped drive, and the UNC >refers to that same drive, the UNC in the link is updated to the mapped drive designation.
Thinking that I had struck gold, I compared the set up (mapped drives, shortcuts etc) to another user's machine to identify a difference. The other machine has no issues but has the network location mapped exactly the same, as the same drive letter.
As a result this machine cannot be used to edit these shared workbooks, as if it saves it, it no longer points to the correct workbook on the network (eg it won't point to \networkdataexcelshared, but instread will refer to the location machine)
Any ideas?
microsoft-excel microsoft-excel-2010 network-shares
edited Jan 14 '15 at 11:29
Dave
23.4k84463
asked Jan 14 '15 at 11:24
RASBRASB
112515
Excel documents stored on network drive, for example, \networkdataExcelShared
Data workbook.xls contains tables with data entered into.
Report.xls contains UNC paths pointing to \networkdataexcelsharedworkbook.xls
Users enter data into data workbook.xls, and then see this reflected in report.xls- one workbook pulls data from the other.
One machine is giving issues. If this machine opens, edits and saves these documents, it changes the paths to reflect the local machine!
The machine has the path mapped as a drive, eg H: (\networkdataexcelshared), so opening a file from here will give the path H:data workbook.xls. I came across this article online which seems to talk about a similar issue-
The Knowledge Base article indicates that if a workbook is opened from a mapped drive, and the UNC >refers to that same drive, the UNC in the link is updated to the mapped drive designation.
Thinking that I had struck gold, I compared the set up (mapped drives, shortcuts etc) to another user's machine to identify a difference. The other machine has no issues but has the network location mapped exactly the same, as the same drive letter.
As a result this machine cannot be used to edit these shared workbooks, as if it saves it, it no longer points to the correct workbook on the network (eg it won't point to \networkdataexcelshared, but instread will refer to the location machine)
Any ideas?
microsoft-excel microsoft-excel-2010 network-shares
microsoft-excel microsoft-excel-2010 network-shares
edited Jan 14 '15 at 11:29
Dave
23.4k84463
asked Jan 14 '15 at 11:24
RASBRASB
112515
edited Jan 14 '15 at 11:29
Dave
23.4k84463
asked Jan 14 '15 at 11:24
RASBRASB
112515
edited Jan 14 '15 at 11:29
Dave
23.4k84463
edited Jan 14 '15 at 11:29
Dave
23.4k84463
edited Jan 14 '15 at 11:29
Dave
23.4k84463
23.4k84463
asked Jan 14 '15 at 11:24
RASBRASB
112515
asked Jan 14 '15 at 11:24
RASBRASB
112515
asked Jan 14 '15 at 11:24
RASBRASB
112515
112515
bumped to the homepage by Community♦ 4 hours 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♦ 4 hours 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 |
4 Answers
4
active
oldest
votes
According to Microsoft, this is typical behavior established by the method the file is opened.
When a source data workbook is linked, the link is established based
on the way that the workbook was opened. If the workbook was opened
over a mapped drive, the link is created by using a mapped drive. The
link remains that way regardless of how the source data workbook is
opened in the future. If the source data file is opened by a UNC path,
the link does not revert to a mapped drive, even if a matching drive
is available. source
The likely cause is the file being opened differently on the various computers, some using the UNC and the other using a mapped path.
answered Jan 14 '15 at 13:39
CharlieRBCharlieRB
20.6k44493
To add a solution to CharlieRB's answer: Try making a shortcut that uses the UNC path on the bothersome machine. It will require human discipline to open the file using that shortcut instead of whatever the user's current method. It would also behoove you to find out what their current method is and try to switch it to a UNC path at some point.
– Engineer Toast
Jan 20 '15 at 19:56
add a comment |
I have had this issue with a few clients. Both were using a mapped drive to access the file. One user would open the file, it would change the links to %appdata%XLSTART*corresponding file path to mapped drive*
I addressed this by making Excel open in the mapped drive for these users. Options, Advanced, General, At Startup, open all files in: (put the network path).
answered Mar 12 '15 at 11:08
TsmithTsmith
1
We use several mapped drives, often with Excel files from each. Should it be a specific one?
– RASB
Mar 12 '15 at 11:30
add a comment |
I usually open my files via the Explorer window, and got into this issue when I didn't notice the UNC path in the header bar; it used to be the full regular path. I set my shortcuts to the network folders, but they were all created as as UNC paths.
I opened up a fresh window, navigated to the network drive; all new links would now show up correctly. Killed all old Favorites; new ones now work fine.
Anil
answered Jul 24 '15 at 16:06
AnilAnil
1
add a comment |
Using a simple macro I tried to refresh the default file path each time before saving.
sub saveme()
Application.DefaultFilePath = "blablablabla$"
thisworkbook.save
end sub()
This seems to work.
answered Sep 19 '18 at 12:46
user945687user945687
1
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%2f864581%2fexcel-changing-unc-paths-in-shared-workbook%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
4 Answers
4
active
oldest
votes
4 Answers
4
active
oldest
votes
active
oldest
votes
active
oldest
votes
According to Microsoft, this is typical behavior established by the method the file is opened.
When a source data workbook is linked, the link is established based
on the way that the workbook was opened. If the workbook was opened
over a mapped drive, the link is created by using a mapped drive. The
link remains that way regardless of how the source data workbook is
opened in the future. If the source data file is opened by a UNC path,
the link does not revert to a mapped drive, even if a matching drive
is available. source
The likely cause is the file being opened differently on the various computers, some using the UNC and the other using a mapped path.
answered Jan 14 '15 at 13:39
CharlieRBCharlieRB
20.6k44493
To add a solution to CharlieRB's answer: Try making a shortcut that uses the UNC path on the bothersome machine. It will require human discipline to open the file using that shortcut instead of whatever the user's current method. It would also behoove you to find out what their current method is and try to switch it to a UNC path at some point.
– Engineer Toast
Jan 20 '15 at 19:56
add a comment |
According to Microsoft, this is typical behavior established by the method the file is opened.
When a source data workbook is linked, the link is established based
on the way that the workbook was opened. If the workbook was opened
over a mapped drive, the link is created by using a mapped drive. The
link remains that way regardless of how the source data workbook is
opened in the future. If the source data file is opened by a UNC path,
the link does not revert to a mapped drive, even if a matching drive
is available. source
The likely cause is the file being opened differently on the various computers, some using the UNC and the other using a mapped path.
answered Jan 14 '15 at 13:39
CharlieRBCharlieRB
20.6k44493
To add a solution to CharlieRB's answer: Try making a shortcut that uses the UNC path on the bothersome machine. It will require human discipline to open the file using that shortcut instead of whatever the user's current method. It would also behoove you to find out what their current method is and try to switch it to a UNC path at some point.
– Engineer Toast
Jan 20 '15 at 19:56
add a comment |
According to Microsoft, this is typical behavior established by the method the file is opened.
When a source data workbook is linked, the link is established based
on the way that the workbook was opened. If the workbook was opened
over a mapped drive, the link is created by using a mapped drive. The
link remains that way regardless of how the source data workbook is
opened in the future. If the source data file is opened by a UNC path,
the link does not revert to a mapped drive, even if a matching drive
is available. source
The likely cause is the file being opened differently on the various computers, some using the UNC and the other using a mapped path.
answered Jan 14 '15 at 13:39
CharlieRBCharlieRB
20.6k44493
According to Microsoft, this is typical behavior established by the method the file is opened.
When a source data workbook is linked, the link is established based
on the way that the workbook was opened. If the workbook was opened
over a mapped drive, the link is created by using a mapped drive. The
link remains that way regardless of how the source data workbook is
opened in the future. If the source data file is opened by a UNC path,
the link does not revert to a mapped drive, even if a matching drive
is available. source
The likely cause is the file being opened differently on the various computers, some using the UNC and the other using a mapped path.
answered Jan 14 '15 at 13:39
CharlieRBCharlieRB
20.6k44493
answered Jan 14 '15 at 13:39
CharlieRBCharlieRB
20.6k44493
answered Jan 14 '15 at 13:39
CharlieRBCharlieRB
20.6k44493
answered Jan 14 '15 at 13:39
CharlieRBCharlieRB
20.6k44493
20.6k44493
To add a solution to CharlieRB's answer: Try making a shortcut that uses the UNC path on the bothersome machine. It will require human discipline to open the file using that shortcut instead of whatever the user's current method. It would also behoove you to find out what their current method is and try to switch it to a UNC path at some point.
– Engineer Toast
Jan 20 '15 at 19:56
add a comment |
To add a solution to CharlieRB's answer: Try making a shortcut that uses the UNC path on the bothersome machine. It will require human discipline to open the file using that shortcut instead of whatever the user's current method. It would also behoove you to find out what their current method is and try to switch it to a UNC path at some point.
– Engineer Toast
Jan 20 '15 at 19:56
To add a solution to CharlieRB's answer: Try making a shortcut that uses the UNC path on the bothersome machine. It will require human discipline to open the file using that shortcut instead of whatever the user's current method. It would also behoove you to find out what their current method is and try to switch it to a UNC path at some point.
– Engineer Toast
Jan 20 '15 at 19:56
To add a solution to CharlieRB's answer: Try making a shortcut that uses the UNC path on the bothersome machine. It will require human discipline to open the file using that shortcut instead of whatever the user's current method. It would also behoove you to find out what their current method is and try to switch it to a UNC path at some point.
– Engineer Toast
Jan 20 '15 at 19:56
add a comment |
I have had this issue with a few clients. Both were using a mapped drive to access the file. One user would open the file, it would change the links to %appdata%XLSTART*corresponding file path to mapped drive*
I addressed this by making Excel open in the mapped drive for these users. Options, Advanced, General, At Startup, open all files in: (put the network path).
answered Mar 12 '15 at 11:08
TsmithTsmith
1
We use several mapped drives, often with Excel files from each. Should it be a specific one?
– RASB
Mar 12 '15 at 11:30
add a comment |
I have had this issue with a few clients. Both were using a mapped drive to access the file. One user would open the file, it would change the links to %appdata%XLSTART*corresponding file path to mapped drive*
I addressed this by making Excel open in the mapped drive for these users. Options, Advanced, General, At Startup, open all files in: (put the network path).
answered Mar 12 '15 at 11:08
TsmithTsmith
1
We use several mapped drives, often with Excel files from each. Should it be a specific one?
– RASB
Mar 12 '15 at 11:30
add a comment |
I have had this issue with a few clients. Both were using a mapped drive to access the file. One user would open the file, it would change the links to %appdata%XLSTART*corresponding file path to mapped drive*
I addressed this by making Excel open in the mapped drive for these users. Options, Advanced, General, At Startup, open all files in: (put the network path).
answered Mar 12 '15 at 11:08
TsmithTsmith
1
I have had this issue with a few clients. Both were using a mapped drive to access the file. One user would open the file, it would change the links to %appdata%XLSTART*corresponding file path to mapped drive*
I addressed this by making Excel open in the mapped drive for these users. Options, Advanced, General, At Startup, open all files in: (put the network path).
answered Mar 12 '15 at 11:08
TsmithTsmith
1
answered Mar 12 '15 at 11:08
TsmithTsmith
1
answered Mar 12 '15 at 11:08
TsmithTsmith
1
answered Mar 12 '15 at 11:08
TsmithTsmith
1
1
We use several mapped drives, often with Excel files from each. Should it be a specific one?
– RASB
Mar 12 '15 at 11:30
add a comment |
We use several mapped drives, often with Excel files from each. Should it be a specific one?
– RASB
Mar 12 '15 at 11:30
We use several mapped drives, often with Excel files from each. Should it be a specific one?
– RASB
Mar 12 '15 at 11:30
We use several mapped drives, often with Excel files from each. Should it be a specific one?
– RASB
Mar 12 '15 at 11:30
add a comment |
I usually open my files via the Explorer window, and got into this issue when I didn't notice the UNC path in the header bar; it used to be the full regular path. I set my shortcuts to the network folders, but they were all created as as UNC paths.
I opened up a fresh window, navigated to the network drive; all new links would now show up correctly. Killed all old Favorites; new ones now work fine.
Anil
answered Jul 24 '15 at 16:06
AnilAnil
1
add a comment |
I usually open my files via the Explorer window, and got into this issue when I didn't notice the UNC path in the header bar; it used to be the full regular path. I set my shortcuts to the network folders, but they were all created as as UNC paths.
I opened up a fresh window, navigated to the network drive; all new links would now show up correctly. Killed all old Favorites; new ones now work fine.
Anil
answered Jul 24 '15 at 16:06
AnilAnil
1
add a comment |
I usually open my files via the Explorer window, and got into this issue when I didn't notice the UNC path in the header bar; it used to be the full regular path. I set my shortcuts to the network folders, but they were all created as as UNC paths.
I opened up a fresh window, navigated to the network drive; all new links would now show up correctly. Killed all old Favorites; new ones now work fine.
Anil
answered Jul 24 '15 at 16:06
AnilAnil
1
I usually open my files via the Explorer window, and got into this issue when I didn't notice the UNC path in the header bar; it used to be the full regular path. I set my shortcuts to the network folders, but they were all created as as UNC paths.
I opened up a fresh window, navigated to the network drive; all new links would now show up correctly. Killed all old Favorites; new ones now work fine.
Anil
answered Jul 24 '15 at 16:06
AnilAnil
1
answered Jul 24 '15 at 16:06
AnilAnil
1
answered Jul 24 '15 at 16:06
AnilAnil
1
answered Jul 24 '15 at 16:06
AnilAnil
1
1
add a comment |
add a comment |
Using a simple macro I tried to refresh the default file path each time before saving.
sub saveme()
Application.DefaultFilePath = "blablablabla$"
thisworkbook.save
end sub()
This seems to work.
answered Sep 19 '18 at 12:46
user945687user945687
1
add a comment |
Using a simple macro I tried to refresh the default file path each time before saving.
sub saveme()
Application.DefaultFilePath = "blablablabla$"
thisworkbook.save
end sub()
This seems to work.
answered Sep 19 '18 at 12:46
user945687user945687
1
add a comment |
Using a simple macro I tried to refresh the default file path each time before saving.
sub saveme()
Application.DefaultFilePath = "blablablabla$"
thisworkbook.save
end sub()
This seems to work.
answered Sep 19 '18 at 12:46
user945687user945687
1
Using a simple macro I tried to refresh the default file path each time before saving.
sub saveme()
Application.DefaultFilePath = "blablablabla$"
thisworkbook.save
end sub()
This seems to work.
answered Sep 19 '18 at 12:46
user945687user945687
1
answered Sep 19 '18 at 12:46
user945687user945687
1
answered Sep 19 '18 at 12:46
user945687user945687
1
answered Sep 19 '18 at 12:46
user945687user945687
1
1
add a comment |
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%2f864581%2fexcel-changing-unc-paths-in-shared-workbook%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
