1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#AI formula generation techniques
#Excel alternatives for data analysis
#formula generator
#Excel compatibility
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#machine learning in spreadsheet applications
#generative AI for data analysis
#Excel
#formula
#SUM
#SUMPRODUCT
#Formula AutoComplete
#recent formulas list
#workbook
#cache issue
#account syncing
#Microsoft 365
#Windows 11