•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel inserts old unwanted formula. How to stop it?
Our take
If you've encountered Excel inserting an old, unwanted formula every time you type a quotation mark, you're not alone. This frustrating issue can stem from various sources, including cached data or auto-complete functions. Despite reaching out to your IT department, the mystery remains unsolved. In this guide, we'll explore practical steps to identify and resolve this problem, ensuring your spreadsheet experience is smooth and efficient. Let’s dive into effective solutions to help you regain control over your formulas and enhance your productivity.
for the last few weeks, every time I'm typing a formula and use a quotation mark, excel inserts a long formula that I wrote about 3 months prior. I can't find where it is stored or why it keeps popping up. any ideas? I've even contacted our IT department to see if it's coming from OneDrive or Sharepoint and they're stumped.
Any help is appreciated.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- 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]
Tagged with
#Excel alternatives for data analysis#AI formula generation techniques#Excel compatibility#formula generator#Excel alternatives#rows.com#natural language processing for spreadsheets#generative AI for data analysis#real-time data collaboration#real-time collaboration#Excel#formula#old formula#quotation mark#long formula#OneDrive#Sharepoint#IT department#auto-fill#software bug