Enable Macros in Excel without Updating External File Links
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have excel documents that have links to extenal files in cells to grab data. These files also have macros. I need to move these excel documents between computers that do and don't have the external files on them and have the macros enabled in all contexts. For Computers running windows 10 and Excel 2016 without the external files clicking the "Enable Content" button will cause excel to hang for about 10 minutes before a "Can't update links" dialog pops up.
How can I enable my macros without causing excel to try and update my links automatically?
microsoft-excel macros microsoft-excel-2016
edited Feb 1 at 0:57
angelofdev
929120
asked Jan 31 at 20:50
user992627user992627
1
add a comment |
I have excel documents that have links to extenal files in cells to grab data. These files also have macros. I need to move these excel documents between computers that do and don't have the external files on them and have the macros enabled in all contexts. For Computers running windows 10 and Excel 2016 without the external files clicking the "Enable Content" button will cause excel to hang for about 10 minutes before a "Can't update links" dialog pops up.
How can I enable my macros without causing excel to try and update my links automatically?
microsoft-excel macros microsoft-excel-2016
edited Feb 1 at 0:57
angelofdev
929120
asked Jan 31 at 20:50
user992627user992627
1
add a comment |
I have excel documents that have links to extenal files in cells to grab data. These files also have macros. I need to move these excel documents between computers that do and don't have the external files on them and have the macros enabled in all contexts. For Computers running windows 10 and Excel 2016 without the external files clicking the "Enable Content" button will cause excel to hang for about 10 minutes before a "Can't update links" dialog pops up.
How can I enable my macros without causing excel to try and update my links automatically?
microsoft-excel macros microsoft-excel-2016
edited Feb 1 at 0:57
angelofdev
929120
asked Jan 31 at 20:50
user992627user992627
1
I have excel documents that have links to extenal files in cells to grab data. These files also have macros. I need to move these excel documents between computers that do and don't have the external files on them and have the macros enabled in all contexts. For Computers running windows 10 and Excel 2016 without the external files clicking the "Enable Content" button will cause excel to hang for about 10 minutes before a "Can't update links" dialog pops up.
How can I enable my macros without causing excel to try and update my links automatically?
microsoft-excel macros microsoft-excel-2016
microsoft-excel macros microsoft-excel-2016
edited Feb 1 at 0:57
angelofdev
929120
asked Jan 31 at 20:50
user992627user992627
1
edited Feb 1 at 0:57
angelofdev
929120
asked Jan 31 at 20:50
user992627user992627
1
edited Feb 1 at 0:57
angelofdev
929120
edited Feb 1 at 0:57
angelofdev
929120
edited Feb 1 at 0:57
angelofdev
929120
929120
asked Jan 31 at 20:50
user992627user992627
1
asked Jan 31 at 20:50
user992627user992627
1
asked Jan 31 at 20:50
user992627user992627
1
1
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I'm the orginal poster and I found a solution that worked for me.
I was able to handle this by using another spreadsheet that opens the problem file using VBA.
Code:
Public file As String
Sub Open_File()
file = Application.ActiveWorkbook.Path + "" + Worksheets("Sheet1").Range("D4").Value
Workbooks.Open fileName:=file, UpdateLinks:=0
End Sub
Spreadsheet:
The Open File button is linked to the Open_File() function in VBA. It will open a file in the same folder as this file with a name set in Cell D4. The opened file won't update links and its marcos will be enabled.
answered Feb 4 at 17:27
McGregor CrowleyMcGregor Crowley
112
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%2f1400751%2fenable-macros-in-excel-without-updating-external-file-links%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
I'm the orginal poster and I found a solution that worked for me.
I was able to handle this by using another spreadsheet that opens the problem file using VBA.
Code:
Public file As String
Sub Open_File()
file = Application.ActiveWorkbook.Path + "" + Worksheets("Sheet1").Range("D4").Value
Workbooks.Open fileName:=file, UpdateLinks:=0
End Sub
Spreadsheet:
The Open File button is linked to the Open_File() function in VBA. It will open a file in the same folder as this file with a name set in Cell D4. The opened file won't update links and its marcos will be enabled.
answered Feb 4 at 17:27
McGregor CrowleyMcGregor Crowley
112
add a comment |
I'm the orginal poster and I found a solution that worked for me.
I was able to handle this by using another spreadsheet that opens the problem file using VBA.
Code:
Public file As String
Sub Open_File()
file = Application.ActiveWorkbook.Path + "" + Worksheets("Sheet1").Range("D4").Value
Workbooks.Open fileName:=file, UpdateLinks:=0
End Sub
Spreadsheet:
The Open File button is linked to the Open_File() function in VBA. It will open a file in the same folder as this file with a name set in Cell D4. The opened file won't update links and its marcos will be enabled.
answered Feb 4 at 17:27
McGregor CrowleyMcGregor Crowley
112
add a comment |
I'm the orginal poster and I found a solution that worked for me.
I was able to handle this by using another spreadsheet that opens the problem file using VBA.
Code:
Public file As String
Sub Open_File()
file = Application.ActiveWorkbook.Path + "" + Worksheets("Sheet1").Range("D4").Value
Workbooks.Open fileName:=file, UpdateLinks:=0
End Sub
Spreadsheet:
The Open File button is linked to the Open_File() function in VBA. It will open a file in the same folder as this file with a name set in Cell D4. The opened file won't update links and its marcos will be enabled.
answered Feb 4 at 17:27
McGregor CrowleyMcGregor Crowley
112
I'm the orginal poster and I found a solution that worked for me.
I was able to handle this by using another spreadsheet that opens the problem file using VBA.
Code:
Public file As String
Sub Open_File()
file = Application.ActiveWorkbook.Path + "" + Worksheets("Sheet1").Range("D4").Value
Workbooks.Open fileName:=file, UpdateLinks:=0
End Sub
Spreadsheet:
The Open File button is linked to the Open_File() function in VBA. It will open a file in the same folder as this file with a name set in Cell D4. The opened file won't update links and its marcos will be enabled.
answered Feb 4 at 17:27
McGregor CrowleyMcGregor Crowley
112
edited Feb 4 at 20:10
answered Feb 4 at 17:27
McGregor CrowleyMcGregor Crowley
112
answered Feb 4 at 17:27
McGregor CrowleyMcGregor Crowley
112
answered Feb 4 at 17:27
McGregor CrowleyMcGregor Crowley
112
112
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%2f1400751%2fenable-macros-in-excel-without-updating-external-file-links%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
