•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Why does excel constantly recalculate when I change something minor?
Our take
If you've ever felt the frustration of Excel recalculating all formulas after a minor change, you're not alone. Many users, like you, are baffled by how a simple adjustment—such as changing a cell color—can trigger lengthy recalculations. This shift in behavior often stems from Excel's automatic calculation settings, introduced in earlier versions. However, you can regain control over your spreadsheets. In this guide, we’ll explore how to adjust your settings and optimize performance, helping you save time and streamline your workflow.
This started happening years ago but its driving me particullary crazy today.
A few years back something changed where when I would make even just the most minor change, all formulas in a spreadsheet would recalculate. For example, if all I did was change a cell color to red, I might be sitting there for 30 seconds waiting (even if the cell I'm recolouring is empty).
It's just happened again. I have a page with 4 columns of sumifs in cells E to H (which I know are quite heavy on calculations) but all I did was delete a few cells from my table all the way over in cells K6 to R13 (I essentially removed the top row) and now I've gotta wait 10 minutes for all my sumifs to recalculate again even though I've not touched them at all.
It never used to do this so I dont think its a 'well thats just how excel works' so something must have changed. Is there a setting I can use to stop this happening?
Thanks
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to Identify Cause of Calculating Threads?I have a light excel file around 10mb. However, it takes a while to update / refresh with any formula given that it always shows Calculating threads (sometimes it's 6 threads, other times 14 threads) There are quite a number of worksheets - maybe around 10. formulas refer to other worksheets in the file and there are formulas linked to 10 external files (mostly VLOOKUP, XLOOKUP). Is there a quite way to identify what's causing the slowdown / calculating threads so I can address? by theory, what causes this? I'm tired of waiting 10mins just to get a simple sum or division. It seems like the Excel needs to recalculate all formulas every single time. Already tried making calculations manual instead of automatic. It helps not to update every single time, so I can wait for all formula adjustments before clicking F9. But, another 5-10mins wait once I do update. submitted by /u/Recent__Craft [link] [comments]
- Font formatting of a calculation dashboard KEEPS reverting every time the data in the other sheets is updatedI am at my wits end, every time I open this spreadsheet the formatting of these cells (supposed to be large and extremely readable to low-tech users on same team) reverts back to Calibri size 11 for some reason. I even created a custom cell style to try and force it to stay that way and I can see that it's selected in the menu, but not reflected whatsoever. Is it just impossible to format cells with a constantly changing calculation? What can I do here?? I feel like I have gone through every formatting constraint/rule there is to try and force it to behave but it always changes back, even if its not right away. It's a spreadsheet stored on sharepoint primarily but I don't know if that makes a difference. Advice appreciated. 😞 submitted by /u/vailette [link] [comments]
- Excel formula automatically rewriting itself??Hi all, this is a really odd problem to run into and I am unsure how to proceed from here. I am currently entering data and I have Excel performing an =SUM(B5:AC5) for my data that is being entered. Because the data entry can go pretty fast sometimes, I would keep entering data past AC5 before I realize what happened. When I look at my SUM column, Excel has flagged my =SUM(B5:AC5) formula with the error below, which is fine and whatever, but it is automatically changing my =SUM(B5:AC5) formula to =SUM(B5:AF5) or something of similar depending on what column I stopped at. Just for reference, data from AD5 to AO5 is being summed up in another column with SUM=(AD5:AO5). Formula error being flagged by Excel I have no idea why it is doing this and I tried to ignore error, but it still automatically rewriting my formula anyways! This worksheet and formula worked smoothly 4 months ago so I don't know what is going on. submitted by /u/WildKhanine [link] [comments]
- Excel keeps inserting an old formula I don't want. How do I stop this?I have a strange problem. Whenever I start typing a formula in a new cell, Excel automatically suggests and inserts an old formula that I used months ago in a completely different workbook. It happens after I type the equals sign and the first letter. For example, I want to use SUM, but Excel fills in a long SUMPRODUCT formula from an old project. I have tried clearing the recent formulas list and turning off Formula AutoComplete in Options, but the behavior still happens. Does Excel store formula history somewhere outside the current workbook? Could this be a cache issue or something related to my account syncing across workbooks? I am using Microsoft 365 on Windows 11. This does not happen on other computers, only my main machine. Any help would be great. submitted by /u/Luann97 [link] [comments]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#rows.com#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#row zero#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#financial modeling with spreadsheets#automation in spreadsheet workflows#no-code spreadsheet solutions#Excel#recalculate#formulas#spreadsheet