Excel hangs when trying to save a shared file
I have a fairly large spreadsheet (~ 5MB) shared between several users. While some users have no problems, some see Excel hang when they try to save their changes. It can happen when they are the only ones using the file, or in a shared situation (in which case they block everyone else). All have the same PC configuration.
Any clue or suggestion would be greatly appreciated.
microsoft-excel microsoft-excel-2010
edited Mar 24 '15 at 8:25
DavidPostill♦
106k26228263
asked Mar 24 '15 at 8:15
BernardBernard
612
add a comment |
I have a fairly large spreadsheet (~ 5MB) shared between several users. While some users have no problems, some see Excel hang when they try to save their changes. It can happen when they are the only ones using the file, or in a shared situation (in which case they block everyone else). All have the same PC configuration.
Any clue or suggestion would be greatly appreciated.
microsoft-excel microsoft-excel-2010
edited Mar 24 '15 at 8:25
DavidPostill♦
106k26228263
asked Mar 24 '15 at 8:15
BernardBernard
612
1
I had the same problem a few years ago. We shared an Excel (with macro's) with about 6 people. It was horrible ... Nothing much you can do about it. You can check some suggestions here
– CustomX
Mar 24 '15 at 10:16
1
This post (by a reputable user) says, "Sharing Excel workbooks only leads to trouble, because it's a question of when not if the shared file becomes corrupt and unusable."
– Scott
Mar 24 '15 at 12:33
After sharing an Excel spreadsheet for a while, it becomes confused has to who actually still has the workbook open. I have found that unsharing the workbook, saving it, then resharing it again usually worked. I believe, though don't know with absolute certainty, that this happens when people close Windows without first closing a shared workbook. I suspect this because I always close all apps before shutting down Windows, and I have never seen my ID twice in Excel's shared list.
– BillDOe
Mar 25 '15 at 5:51
To add to BillOers comment, you can open the sharing screen and kick users that aren't actually inside the document. I guess it's the same thing, just a different approach.
– CustomX
Mar 25 '15 at 7:53
add a comment |
I have a fairly large spreadsheet (~ 5MB) shared between several users. While some users have no problems, some see Excel hang when they try to save their changes. It can happen when they are the only ones using the file, or in a shared situation (in which case they block everyone else). All have the same PC configuration.
Any clue or suggestion would be greatly appreciated.
microsoft-excel microsoft-excel-2010
edited Mar 24 '15 at 8:25
DavidPostill♦
106k26228263
asked Mar 24 '15 at 8:15
BernardBernard
612
I have a fairly large spreadsheet (~ 5MB) shared between several users. While some users have no problems, some see Excel hang when they try to save their changes. It can happen when they are the only ones using the file, or in a shared situation (in which case they block everyone else). All have the same PC configuration.
Any clue or suggestion would be greatly appreciated.
microsoft-excel microsoft-excel-2010
microsoft-excel microsoft-excel-2010
edited Mar 24 '15 at 8:25
DavidPostill♦
106k26228263
asked Mar 24 '15 at 8:15
BernardBernard
612
edited Mar 24 '15 at 8:25
DavidPostill♦
106k26228263
asked Mar 24 '15 at 8:15
BernardBernard
612
edited Mar 24 '15 at 8:25
DavidPostill♦
106k26228263
edited Mar 24 '15 at 8:25
DavidPostill♦
106k26228263
edited Mar 24 '15 at 8:25
DavidPostill♦
106k26228263
106k26228263
asked Mar 24 '15 at 8:15
BernardBernard
612
asked Mar 24 '15 at 8:15
BernardBernard
612
asked Mar 24 '15 at 8:15
BernardBernard
612
612
1
I had the same problem a few years ago. We shared an Excel (with macro's) with about 6 people. It was horrible ... Nothing much you can do about it. You can check some suggestions here
– CustomX
Mar 24 '15 at 10:16
1
This post (by a reputable user) says, "Sharing Excel workbooks only leads to trouble, because it's a question of when not if the shared file becomes corrupt and unusable."
– Scott
Mar 24 '15 at 12:33
After sharing an Excel spreadsheet for a while, it becomes confused has to who actually still has the workbook open. I have found that unsharing the workbook, saving it, then resharing it again usually worked. I believe, though don't know with absolute certainty, that this happens when people close Windows without first closing a shared workbook. I suspect this because I always close all apps before shutting down Windows, and I have never seen my ID twice in Excel's shared list.
– BillDOe
Mar 25 '15 at 5:51
To add to BillOers comment, you can open the sharing screen and kick users that aren't actually inside the document. I guess it's the same thing, just a different approach.
– CustomX
Mar 25 '15 at 7:53
add a comment |
1
I had the same problem a few years ago. We shared an Excel (with macro's) with about 6 people. It was horrible ... Nothing much you can do about it. You can check some suggestions here
– CustomX
Mar 24 '15 at 10:16
1
This post (by a reputable user) says, "Sharing Excel workbooks only leads to trouble, because it's a question of when not if the shared file becomes corrupt and unusable."
– Scott
Mar 24 '15 at 12:33
After sharing an Excel spreadsheet for a while, it becomes confused has to who actually still has the workbook open. I have found that unsharing the workbook, saving it, then resharing it again usually worked. I believe, though don't know with absolute certainty, that this happens when people close Windows without first closing a shared workbook. I suspect this because I always close all apps before shutting down Windows, and I have never seen my ID twice in Excel's shared list.
– BillDOe
Mar 25 '15 at 5:51
To add to BillOers comment, you can open the sharing screen and kick users that aren't actually inside the document. I guess it's the same thing, just a different approach.
– CustomX
Mar 25 '15 at 7:53
1
1
I had the same problem a few years ago. We shared an Excel (with macro's) with about 6 people. It was horrible ... Nothing much you can do about it. You can check some suggestions here
– CustomX
Mar 24 '15 at 10:16
I had the same problem a few years ago. We shared an Excel (with macro's) with about 6 people. It was horrible ... Nothing much you can do about it. You can check some suggestions here
– CustomX
Mar 24 '15 at 10:16
1
1
This post (by a reputable user) says, "Sharing Excel workbooks only leads to trouble, because it's a question of when not if the shared file becomes corrupt and unusable."
– Scott
Mar 24 '15 at 12:33
This post (by a reputable user) says, "Sharing Excel workbooks only leads to trouble, because it's a question of when not if the shared file becomes corrupt and unusable."
– Scott
Mar 24 '15 at 12:33
After sharing an Excel spreadsheet for a while, it becomes confused has to who actually still has the workbook open. I have found that unsharing the workbook, saving it, then resharing it again usually worked. I believe, though don't know with absolute certainty, that this happens when people close Windows without first closing a shared workbook. I suspect this because I always close all apps before shutting down Windows, and I have never seen my ID twice in Excel's shared list.
– BillDOe
Mar 25 '15 at 5:51
After sharing an Excel spreadsheet for a while, it becomes confused has to who actually still has the workbook open. I have found that unsharing the workbook, saving it, then resharing it again usually worked. I believe, though don't know with absolute certainty, that this happens when people close Windows without first closing a shared workbook. I suspect this because I always close all apps before shutting down Windows, and I have never seen my ID twice in Excel's shared list.
– BillDOe
Mar 25 '15 at 5:51
To add to BillOers comment, you can open the sharing screen and kick users that aren't actually inside the document. I guess it's the same thing, just a different approach.
– CustomX
Mar 25 '15 at 7:53
To add to BillOers comment, you can open the sharing screen and kick users that aren't actually inside the document. I guess it's the same thing, just a different approach.
– CustomX
Mar 25 '15 at 7:53
add a comment |
1 Answer
1
active
oldest
votes
Take a look at my answer here I was in a similar situation and it is most likely caused from excel thinking users are logged in when they are not and tons of custom views being saved in the file my script clears all that out.
How do you prevent corruption of shared Excel files?
answered Aug 24 '15 at 11:48
Matthew LozoyaMatthew Lozoya
244213
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%2f893243%2fexcel-hangs-when-trying-to-save-a-shared-file%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
Take a look at my answer here I was in a similar situation and it is most likely caused from excel thinking users are logged in when they are not and tons of custom views being saved in the file my script clears all that out.
How do you prevent corruption of shared Excel files?
answered Aug 24 '15 at 11:48
Matthew LozoyaMatthew Lozoya
244213
add a comment |
Take a look at my answer here I was in a similar situation and it is most likely caused from excel thinking users are logged in when they are not and tons of custom views being saved in the file my script clears all that out.
How do you prevent corruption of shared Excel files?
answered Aug 24 '15 at 11:48
Matthew LozoyaMatthew Lozoya
244213
add a comment |
Take a look at my answer here I was in a similar situation and it is most likely caused from excel thinking users are logged in when they are not and tons of custom views being saved in the file my script clears all that out.
How do you prevent corruption of shared Excel files?
answered Aug 24 '15 at 11:48
Matthew LozoyaMatthew Lozoya
244213
Take a look at my answer here I was in a similar situation and it is most likely caused from excel thinking users are logged in when they are not and tons of custom views being saved in the file my script clears all that out.
How do you prevent corruption of shared Excel files?
answered Aug 24 '15 at 11:48
Matthew LozoyaMatthew Lozoya
244213
answered Aug 24 '15 at 11:48
Matthew LozoyaMatthew Lozoya
244213
answered Aug 24 '15 at 11:48
Matthew LozoyaMatthew Lozoya
244213
answered Aug 24 '15 at 11:48
Matthew LozoyaMatthew Lozoya
244213
244213
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%2f893243%2fexcel-hangs-when-trying-to-save-a-shared-file%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
1
I had the same problem a few years ago. We shared an Excel (with macro's) with about 6 people. It was horrible ... Nothing much you can do about it. You can check some suggestions here
– CustomX
Mar 24 '15 at 10:16
1
This post (by a reputable user) says, "Sharing Excel workbooks only leads to trouble, because it's a question of when not if the shared file becomes corrupt and unusable."
– Scott
Mar 24 '15 at 12:33
After sharing an Excel spreadsheet for a while, it becomes confused has to who actually still has the workbook open. I have found that unsharing the workbook, saving it, then resharing it again usually worked. I believe, though don't know with absolute certainty, that this happens when people close Windows without first closing a shared workbook. I suspect this because I always close all apps before shutting down Windows, and I have never seen my ID twice in Excel's shared list.
– BillDOe
Mar 25 '15 at 5:51
To add to BillOers comment, you can open the sharing screen and kick users that aren't actually inside the document. I guess it's the same thing, just a different approach.
– CustomX
Mar 25 '15 at 7:53