Excel freeze when I change the data of only one cell
Windows 7 Pro, Office Excel 2013, i7 last generation processor, 8 GB RAM.
I'm working on a project of about 25 MB, a lot of index formulas, tables (not range) and everything is local(the info I use is in the same document).
But I have this only sheet that is slower than the rest (the calculation options are in manual mode always), and in these sheet when I change the number of an specific cell, it freezes for about 40 secs (only if I change the data, not with the calculation), also this cell data is used in only 4 cells of the document in different sheets.
I don't know what is happening because I'm in manual mode with formulas. Also in that same sheet when I try to add new rows, it get stuck too.
I have recently had the same problem and I solved it by copy/paste all my work into a new excel workbook. But after 2 weeks It appeared again.
I also don't have any macro or conditional formatting, the document is on my computer (not a network).
In particular:
When I change the data 1 time it freeze, after this if I dont calculate the sheet again, I can change the data freely with no problem. But when I calculate again and then change again the data of the cell it freeze.
freeze microsoft-excel-2013
asked Jan 21 '16 at 18:31
Manuel Aldunate BarrosManuel Aldunate Barros
112
|
show 4 more comments
Windows 7 Pro, Office Excel 2013, i7 last generation processor, 8 GB RAM.
I'm working on a project of about 25 MB, a lot of index formulas, tables (not range) and everything is local(the info I use is in the same document).
But I have this only sheet that is slower than the rest (the calculation options are in manual mode always), and in these sheet when I change the number of an specific cell, it freezes for about 40 secs (only if I change the data, not with the calculation), also this cell data is used in only 4 cells of the document in different sheets.
I don't know what is happening because I'm in manual mode with formulas. Also in that same sheet when I try to add new rows, it get stuck too.
I have recently had the same problem and I solved it by copy/paste all my work into a new excel workbook. But after 2 weeks It appeared again.
I also don't have any macro or conditional formatting, the document is on my computer (not a network).
In particular:
When I change the data 1 time it freeze, after this if I dont calculate the sheet again, I can change the data freely with no problem. But when I calculate again and then change again the data of the cell it freeze.
freeze microsoft-excel-2013
asked Jan 21 '16 at 18:31
Manuel Aldunate BarrosManuel Aldunate Barros
112
Did you try to hit CTRL+BREAK during the delay? If it is running a macro, it would stop there and pop up the debugger; obviously you know what's the problem then.
– Aganju
Jan 21 '16 at 19:56
Try removing all conditional formatting (don't save) and do it then. If the problem is gone, you can selectively remove them to find out which one is it.
– Aganju
Jan 21 '16 at 19:57
I had similar issue if you have the same formula copied in a large range - the first time you edit any of those fields, Excel needs to internally break that 'they are all the same' into 'now I need a gazillion copies'. That's a bit fuzzy worded, because i have no access to Excel code, but that's how it seems.
– Aganju
Jan 21 '16 at 19:59
So what do you recommend to do? Imagine that 8 sheets have to access to this cell, and 2000 formulas in each sheet. The thing is that I already have this problem befor with way fewer data, and a copy/paste everithing in another sheet and the problem dissapear, and now 2 weeks later it appered again, with way more data.
– Manuel Aldunate Barros
Jan 21 '16 at 20:07
1
Lots of formulas and stuff- Sigh... If you're not going to be clear then we can't understand ;) . Please explain what isstuff. Also where is the file saved (locally, network). This is a very strange issue to debug. Please also clarify, is the issue it's slow when you change the data of the cell, or when you perform the calculation? You're best to edit your post with this data so others can read it too :)
– Dave
Jan 22 '16 at 8:38
|
show 4 more comments
Windows 7 Pro, Office Excel 2013, i7 last generation processor, 8 GB RAM.
I'm working on a project of about 25 MB, a lot of index formulas, tables (not range) and everything is local(the info I use is in the same document).
But I have this only sheet that is slower than the rest (the calculation options are in manual mode always), and in these sheet when I change the number of an specific cell, it freezes for about 40 secs (only if I change the data, not with the calculation), also this cell data is used in only 4 cells of the document in different sheets.
I don't know what is happening because I'm in manual mode with formulas. Also in that same sheet when I try to add new rows, it get stuck too.
I have recently had the same problem and I solved it by copy/paste all my work into a new excel workbook. But after 2 weeks It appeared again.
I also don't have any macro or conditional formatting, the document is on my computer (not a network).
In particular:
When I change the data 1 time it freeze, after this if I dont calculate the sheet again, I can change the data freely with no problem. But when I calculate again and then change again the data of the cell it freeze.
freeze microsoft-excel-2013
asked Jan 21 '16 at 18:31
Manuel Aldunate BarrosManuel Aldunate Barros
112
Windows 7 Pro, Office Excel 2013, i7 last generation processor, 8 GB RAM.
I'm working on a project of about 25 MB, a lot of index formulas, tables (not range) and everything is local(the info I use is in the same document).
But I have this only sheet that is slower than the rest (the calculation options are in manual mode always), and in these sheet when I change the number of an specific cell, it freezes for about 40 secs (only if I change the data, not with the calculation), also this cell data is used in only 4 cells of the document in different sheets.
I don't know what is happening because I'm in manual mode with formulas. Also in that same sheet when I try to add new rows, it get stuck too.
I have recently had the same problem and I solved it by copy/paste all my work into a new excel workbook. But after 2 weeks It appeared again.
I also don't have any macro or conditional formatting, the document is on my computer (not a network).
In particular:
When I change the data 1 time it freeze, after this if I dont calculate the sheet again, I can change the data freely with no problem. But when I calculate again and then change again the data of the cell it freeze.
freeze microsoft-excel-2013
freeze microsoft-excel-2013
asked Jan 21 '16 at 18:31
Manuel Aldunate BarrosManuel Aldunate Barros
112
asked Jan 21 '16 at 18:31
Manuel Aldunate BarrosManuel Aldunate Barros
112
edited Jan 22 '16 at 17:01
Manuel Aldunate Barros
asked Jan 21 '16 at 18:31
Manuel Aldunate BarrosManuel Aldunate Barros
112
asked Jan 21 '16 at 18:31
Manuel Aldunate BarrosManuel Aldunate Barros
112
asked Jan 21 '16 at 18:31
Manuel Aldunate BarrosManuel Aldunate Barros
112
112
Did you try to hit CTRL+BREAK during the delay? If it is running a macro, it would stop there and pop up the debugger; obviously you know what's the problem then.
– Aganju
Jan 21 '16 at 19:56
Try removing all conditional formatting (don't save) and do it then. If the problem is gone, you can selectively remove them to find out which one is it.
– Aganju
Jan 21 '16 at 19:57
I had similar issue if you have the same formula copied in a large range - the first time you edit any of those fields, Excel needs to internally break that 'they are all the same' into 'now I need a gazillion copies'. That's a bit fuzzy worded, because i have no access to Excel code, but that's how it seems.
– Aganju
Jan 21 '16 at 19:59
So what do you recommend to do? Imagine that 8 sheets have to access to this cell, and 2000 formulas in each sheet. The thing is that I already have this problem befor with way fewer data, and a copy/paste everithing in another sheet and the problem dissapear, and now 2 weeks later it appered again, with way more data.
– Manuel Aldunate Barros
Jan 21 '16 at 20:07
1
Lots of formulas and stuff- Sigh... If you're not going to be clear then we can't understand ;) . Please explain what isstuff. Also where is the file saved (locally, network). This is a very strange issue to debug. Please also clarify, is the issue it's slow when you change the data of the cell, or when you perform the calculation? You're best to edit your post with this data so others can read it too :)
– Dave
Jan 22 '16 at 8:38
|
show 4 more comments
Did you try to hit CTRL+BREAK during the delay? If it is running a macro, it would stop there and pop up the debugger; obviously you know what's the problem then.
– Aganju
Jan 21 '16 at 19:56
Try removing all conditional formatting (don't save) and do it then. If the problem is gone, you can selectively remove them to find out which one is it.
– Aganju
Jan 21 '16 at 19:57
I had similar issue if you have the same formula copied in a large range - the first time you edit any of those fields, Excel needs to internally break that 'they are all the same' into 'now I need a gazillion copies'. That's a bit fuzzy worded, because i have no access to Excel code, but that's how it seems.
– Aganju
Jan 21 '16 at 19:59
So what do you recommend to do? Imagine that 8 sheets have to access to this cell, and 2000 formulas in each sheet. The thing is that I already have this problem befor with way fewer data, and a copy/paste everithing in another sheet and the problem dissapear, and now 2 weeks later it appered again, with way more data.
– Manuel Aldunate Barros
Jan 21 '16 at 20:07
1
Lots of formulas and stuff- Sigh... If you're not going to be clear then we can't understand ;) . Please explain what isstuff. Also where is the file saved (locally, network). This is a very strange issue to debug. Please also clarify, is the issue it's slow when you change the data of the cell, or when you perform the calculation? You're best to edit your post with this data so others can read it too :)
– Dave
Jan 22 '16 at 8:38
Did you try to hit CTRL+BREAK during the delay? If it is running a macro, it would stop there and pop up the debugger; obviously you know what's the problem then.
– Aganju
Jan 21 '16 at 19:56
Did you try to hit CTRL+BREAK during the delay? If it is running a macro, it would stop there and pop up the debugger; obviously you know what's the problem then.
– Aganju
Jan 21 '16 at 19:56
Try removing all conditional formatting (don't save) and do it then. If the problem is gone, you can selectively remove them to find out which one is it.
– Aganju
Jan 21 '16 at 19:57
Try removing all conditional formatting (don't save) and do it then. If the problem is gone, you can selectively remove them to find out which one is it.
– Aganju
Jan 21 '16 at 19:57
I had similar issue if you have the same formula copied in a large range - the first time you edit any of those fields, Excel needs to internally break that 'they are all the same' into 'now I need a gazillion copies'. That's a bit fuzzy worded, because i have no access to Excel code, but that's how it seems.
– Aganju
Jan 21 '16 at 19:59
I had similar issue if you have the same formula copied in a large range - the first time you edit any of those fields, Excel needs to internally break that 'they are all the same' into 'now I need a gazillion copies'. That's a bit fuzzy worded, because i have no access to Excel code, but that's how it seems.
– Aganju
Jan 21 '16 at 19:59
So what do you recommend to do? Imagine that 8 sheets have to access to this cell, and 2000 formulas in each sheet. The thing is that I already have this problem befor with way fewer data, and a copy/paste everithing in another sheet and the problem dissapear, and now 2 weeks later it appered again, with way more data.
– Manuel Aldunate Barros
Jan 21 '16 at 20:07
So what do you recommend to do? Imagine that 8 sheets have to access to this cell, and 2000 formulas in each sheet. The thing is that I already have this problem befor with way fewer data, and a copy/paste everithing in another sheet and the problem dissapear, and now 2 weeks later it appered again, with way more data.
– Manuel Aldunate Barros
Jan 21 '16 at 20:07
1
1
Lots of formulas and stuff - Sigh... If you're not going to be clear then we can't understand ;) . Please explain what is stuff. Also where is the file saved (locally, network). This is a very strange issue to debug. Please also clarify, is the issue it's slow when you change the data of the cell, or when you perform the calculation? You're best to edit your post with this data so others can read it too :)– Dave
Jan 22 '16 at 8:38
Lots of formulas and stuff - Sigh... If you're not going to be clear then we can't understand ;) . Please explain what is stuff. Also where is the file saved (locally, network). This is a very strange issue to debug. Please also clarify, is the issue it's slow when you change the data of the cell, or when you perform the calculation? You're best to edit your post with this data so others can read it too :)– Dave
Jan 22 '16 at 8:38
|
show 4 more comments
2 Answers
2
active
oldest
votes
Having lots of index/matching can really slow the worksheet down, especially if it's tons of data. I'm assuming your data is in a table-like format, and not just random formulas everywhere.
Say you have an index/match that is in range A1:A1000. Keep A1 as a formula, but take A2:A1000 and copy/paste special as Values. This will keep a formula, in case you need to run it again, but will greatly speed up the worksheet.
Also, check if you have any Volatile functions which could slow it down as well.
Finally, do you have any Worksheet_Change type events in the sheets? That may also contribute to the size/slow down.
answered Jan 21 '16 at 18:56
BruceWayneBruceWayne
768
I appreciate your contribution. But is not about the calculation speed. Because I only recaclulate with F9 , cause I have the calculation on manual mode. When I change the value of only 1 cell (B3) it takes a lot of time (in the others is fast), and when I add a row, only in one of the sheets (the cell B3 with the problem is in the same sheet).
– Manuel Aldunate Barros
Jan 21 '16 at 19:39
@ManuelAldunateBarros - I'm thinking it's freezing as it's recalculating all the formulas. I have had a spreadsheet with TONS of formulas, and when I'd update it (or run a macro), it'd look like Excel froze, but it was actually running behind what appeared to be a frozen screen. That's why I mention trying to reduce the number of live formulas.
– BruceWayne
Jan 21 '16 at 19:41
Yeah I thought that too, but is not all the time, like 1 of 3 times I change the number it collapses. I was thinking that is more about a corruption of the worksheet or something like that... I really don't know..
– Manuel Aldunate Barros
Jan 21 '16 at 19:45
add a comment |
I had this issue and found that the culprit was in my new rules for conditional formatting. They had circular reference. Once removed, everything started working normally. Thank you Aganju for the hint.
When managing conditional rules, ensure to select This Worksheet from the drop-down Show formatting rules for. Otherwise you don't see all rules.
answered Sep 11 '18 at 4:12
SofiaSofia
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%2f1029593%2fexcel-freeze-when-i-change-the-data-of-only-one-cell%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Having lots of index/matching can really slow the worksheet down, especially if it's tons of data. I'm assuming your data is in a table-like format, and not just random formulas everywhere.
Say you have an index/match that is in range A1:A1000. Keep A1 as a formula, but take A2:A1000 and copy/paste special as Values. This will keep a formula, in case you need to run it again, but will greatly speed up the worksheet.
Also, check if you have any Volatile functions which could slow it down as well.
Finally, do you have any Worksheet_Change type events in the sheets? That may also contribute to the size/slow down.
answered Jan 21 '16 at 18:56
BruceWayneBruceWayne
768
I appreciate your contribution. But is not about the calculation speed. Because I only recaclulate with F9 , cause I have the calculation on manual mode. When I change the value of only 1 cell (B3) it takes a lot of time (in the others is fast), and when I add a row, only in one of the sheets (the cell B3 with the problem is in the same sheet).
– Manuel Aldunate Barros
Jan 21 '16 at 19:39
@ManuelAldunateBarros - I'm thinking it's freezing as it's recalculating all the formulas. I have had a spreadsheet with TONS of formulas, and when I'd update it (or run a macro), it'd look like Excel froze, but it was actually running behind what appeared to be a frozen screen. That's why I mention trying to reduce the number of live formulas.
– BruceWayne
Jan 21 '16 at 19:41
Yeah I thought that too, but is not all the time, like 1 of 3 times I change the number it collapses. I was thinking that is more about a corruption of the worksheet or something like that... I really don't know..
– Manuel Aldunate Barros
Jan 21 '16 at 19:45
add a comment |
Having lots of index/matching can really slow the worksheet down, especially if it's tons of data. I'm assuming your data is in a table-like format, and not just random formulas everywhere.
Say you have an index/match that is in range A1:A1000. Keep A1 as a formula, but take A2:A1000 and copy/paste special as Values. This will keep a formula, in case you need to run it again, but will greatly speed up the worksheet.
Also, check if you have any Volatile functions which could slow it down as well.
Finally, do you have any Worksheet_Change type events in the sheets? That may also contribute to the size/slow down.
answered Jan 21 '16 at 18:56
BruceWayneBruceWayne
768
I appreciate your contribution. But is not about the calculation speed. Because I only recaclulate with F9 , cause I have the calculation on manual mode. When I change the value of only 1 cell (B3) it takes a lot of time (in the others is fast), and when I add a row, only in one of the sheets (the cell B3 with the problem is in the same sheet).
– Manuel Aldunate Barros
Jan 21 '16 at 19:39
@ManuelAldunateBarros - I'm thinking it's freezing as it's recalculating all the formulas. I have had a spreadsheet with TONS of formulas, and when I'd update it (or run a macro), it'd look like Excel froze, but it was actually running behind what appeared to be a frozen screen. That's why I mention trying to reduce the number of live formulas.
– BruceWayne
Jan 21 '16 at 19:41
Yeah I thought that too, but is not all the time, like 1 of 3 times I change the number it collapses. I was thinking that is more about a corruption of the worksheet or something like that... I really don't know..
– Manuel Aldunate Barros
Jan 21 '16 at 19:45
add a comment |
Having lots of index/matching can really slow the worksheet down, especially if it's tons of data. I'm assuming your data is in a table-like format, and not just random formulas everywhere.
Say you have an index/match that is in range A1:A1000. Keep A1 as a formula, but take A2:A1000 and copy/paste special as Values. This will keep a formula, in case you need to run it again, but will greatly speed up the worksheet.
Also, check if you have any Volatile functions which could slow it down as well.
Finally, do you have any Worksheet_Change type events in the sheets? That may also contribute to the size/slow down.
answered Jan 21 '16 at 18:56
BruceWayneBruceWayne
768
Having lots of index/matching can really slow the worksheet down, especially if it's tons of data. I'm assuming your data is in a table-like format, and not just random formulas everywhere.
Say you have an index/match that is in range A1:A1000. Keep A1 as a formula, but take A2:A1000 and copy/paste special as Values. This will keep a formula, in case you need to run it again, but will greatly speed up the worksheet.
Also, check if you have any Volatile functions which could slow it down as well.
Finally, do you have any Worksheet_Change type events in the sheets? That may also contribute to the size/slow down.
answered Jan 21 '16 at 18:56
BruceWayneBruceWayne
768
answered Jan 21 '16 at 18:56
BruceWayneBruceWayne
768
answered Jan 21 '16 at 18:56
BruceWayneBruceWayne
768
answered Jan 21 '16 at 18:56
BruceWayneBruceWayne
768
768
I appreciate your contribution. But is not about the calculation speed. Because I only recaclulate with F9 , cause I have the calculation on manual mode. When I change the value of only 1 cell (B3) it takes a lot of time (in the others is fast), and when I add a row, only in one of the sheets (the cell B3 with the problem is in the same sheet).
– Manuel Aldunate Barros
Jan 21 '16 at 19:39
@ManuelAldunateBarros - I'm thinking it's freezing as it's recalculating all the formulas. I have had a spreadsheet with TONS of formulas, and when I'd update it (or run a macro), it'd look like Excel froze, but it was actually running behind what appeared to be a frozen screen. That's why I mention trying to reduce the number of live formulas.
– BruceWayne
Jan 21 '16 at 19:41
Yeah I thought that too, but is not all the time, like 1 of 3 times I change the number it collapses. I was thinking that is more about a corruption of the worksheet or something like that... I really don't know..
– Manuel Aldunate Barros
Jan 21 '16 at 19:45
add a comment |
I appreciate your contribution. But is not about the calculation speed. Because I only recaclulate with F9 , cause I have the calculation on manual mode. When I change the value of only 1 cell (B3) it takes a lot of time (in the others is fast), and when I add a row, only in one of the sheets (the cell B3 with the problem is in the same sheet).
– Manuel Aldunate Barros
Jan 21 '16 at 19:39
@ManuelAldunateBarros - I'm thinking it's freezing as it's recalculating all the formulas. I have had a spreadsheet with TONS of formulas, and when I'd update it (or run a macro), it'd look like Excel froze, but it was actually running behind what appeared to be a frozen screen. That's why I mention trying to reduce the number of live formulas.
– BruceWayne
Jan 21 '16 at 19:41
Yeah I thought that too, but is not all the time, like 1 of 3 times I change the number it collapses. I was thinking that is more about a corruption of the worksheet or something like that... I really don't know..
– Manuel Aldunate Barros
Jan 21 '16 at 19:45
I appreciate your contribution. But is not about the calculation speed. Because I only recaclulate with F9 , cause I have the calculation on manual mode. When I change the value of only 1 cell (B3) it takes a lot of time (in the others is fast), and when I add a row, only in one of the sheets (the cell B3 with the problem is in the same sheet).
– Manuel Aldunate Barros
Jan 21 '16 at 19:39
I appreciate your contribution. But is not about the calculation speed. Because I only recaclulate with F9 , cause I have the calculation on manual mode. When I change the value of only 1 cell (B3) it takes a lot of time (in the others is fast), and when I add a row, only in one of the sheets (the cell B3 with the problem is in the same sheet).
– Manuel Aldunate Barros
Jan 21 '16 at 19:39
@ManuelAldunateBarros - I'm thinking it's freezing as it's recalculating all the formulas. I have had a spreadsheet with TONS of formulas, and when I'd update it (or run a macro), it'd look like Excel froze, but it was actually running behind what appeared to be a frozen screen. That's why I mention trying to reduce the number of live formulas.
– BruceWayne
Jan 21 '16 at 19:41
@ManuelAldunateBarros - I'm thinking it's freezing as it's recalculating all the formulas. I have had a spreadsheet with TONS of formulas, and when I'd update it (or run a macro), it'd look like Excel froze, but it was actually running behind what appeared to be a frozen screen. That's why I mention trying to reduce the number of live formulas.
– BruceWayne
Jan 21 '16 at 19:41
Yeah I thought that too, but is not all the time, like 1 of 3 times I change the number it collapses. I was thinking that is more about a corruption of the worksheet or something like that... I really don't know..
– Manuel Aldunate Barros
Jan 21 '16 at 19:45
Yeah I thought that too, but is not all the time, like 1 of 3 times I change the number it collapses. I was thinking that is more about a corruption of the worksheet or something like that... I really don't know..
– Manuel Aldunate Barros
Jan 21 '16 at 19:45
add a comment |
I had this issue and found that the culprit was in my new rules for conditional formatting. They had circular reference. Once removed, everything started working normally. Thank you Aganju for the hint.
When managing conditional rules, ensure to select This Worksheet from the drop-down Show formatting rules for. Otherwise you don't see all rules.
answered Sep 11 '18 at 4:12
SofiaSofia
1
add a comment |
I had this issue and found that the culprit was in my new rules for conditional formatting. They had circular reference. Once removed, everything started working normally. Thank you Aganju for the hint.
When managing conditional rules, ensure to select This Worksheet from the drop-down Show formatting rules for. Otherwise you don't see all rules.
answered Sep 11 '18 at 4:12
SofiaSofia
1
add a comment |
I had this issue and found that the culprit was in my new rules for conditional formatting. They had circular reference. Once removed, everything started working normally. Thank you Aganju for the hint.
When managing conditional rules, ensure to select This Worksheet from the drop-down Show formatting rules for. Otherwise you don't see all rules.
answered Sep 11 '18 at 4:12
SofiaSofia
1
I had this issue and found that the culprit was in my new rules for conditional formatting. They had circular reference. Once removed, everything started working normally. Thank you Aganju for the hint.
When managing conditional rules, ensure to select This Worksheet from the drop-down Show formatting rules for. Otherwise you don't see all rules.
answered Sep 11 '18 at 4:12
SofiaSofia
1
answered Sep 11 '18 at 4:12
SofiaSofia
1
answered Sep 11 '18 at 4:12
SofiaSofia
1
answered Sep 11 '18 at 4:12
SofiaSofia
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f1029593%2fexcel-freeze-when-i-change-the-data-of-only-one-cell%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
Did you try to hit CTRL+BREAK during the delay? If it is running a macro, it would stop there and pop up the debugger; obviously you know what's the problem then.
– Aganju
Jan 21 '16 at 19:56
Try removing all conditional formatting (don't save) and do it then. If the problem is gone, you can selectively remove them to find out which one is it.
– Aganju
Jan 21 '16 at 19:57
I had similar issue if you have the same formula copied in a large range - the first time you edit any of those fields, Excel needs to internally break that 'they are all the same' into 'now I need a gazillion copies'. That's a bit fuzzy worded, because i have no access to Excel code, but that's how it seems.
– Aganju
Jan 21 '16 at 19:59
So what do you recommend to do? Imagine that 8 sheets have to access to this cell, and 2000 formulas in each sheet. The thing is that I already have this problem befor with way fewer data, and a copy/paste everithing in another sheet and the problem dissapear, and now 2 weeks later it appered again, with way more data.
– Manuel Aldunate Barros
Jan 21 '16 at 20:07
1
Lots of formulas and stuff- Sigh... If you're not going to be clear then we can't understand ;) . Please explain what isstuff. Also where is the file saved (locally, network). This is a very strange issue to debug. Please also clarify, is the issue it's slow when you change the data of the cell, or when you perform the calculation? You're best to edit your post with this data so others can read it too :)– Dave
Jan 22 '16 at 8:38