Excel keeps inserting an old formula I don't want. How do I stop this?
Our take
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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- Need formula to be just the numberI can't seem to get the formula to go away and just be the answer. I have tried copying and pasting with special values, but that also did not work. I am new to Excel and do not fully understand it. https://preview.redd.it/nqjt1a1g5qxg1.png?width=826&format=png&auto=webp&s=5a7942502925fdfc3f189d62218a71622349e5c8 https://preview.redd.it/xht99d7i5qxg1.png?width=680&format=png&auto=webp&s=e6c363ce08480fcdaa6c96ae3f7d834ae9a2b8e2 submitted by /u/graveyard-bones [link] [comments]
- Don’t want formulae to auto update cell once data movesUsing formula =COUNTA($C$5:$C$6000) and have to add rows of data to the top a few times a day. Everytime I add data, $C$5 gets updated to the new location. I want it to always start at C5 The first 4 rows are not merged, but frozen. submitted by /u/remrem24 [link] [comments]