Excel 365 versus Excel 2019 or 2021 lagging, bugs, etc.
The last two years of using Excel 365 desktop for cash flows, waterfalls, etc has been absolutely awful. After many corrupted files, spreadsheets lagging for no reason, random bugs, and literally having to readjust my Options settings every 10 minutes... I need answers because I've tried every "fix" I've researched including using different computers. Also, Microsoft support was less than helpful... they told me they have never even received a complaint about excel ever. Just laughable.

I understand nothing will be perfect so here is my question. Has anyone else had a similar experience with excel 365 and noticed a significant difference after switching to Excel 2019 or 2021?

Also, is 2019 or 2021 the better product in terms of having the least amount of bugs?

Please don't suggest ARGUS because we already have it, and is beside the point because my largest spreadsheet is only 3MB and I know there are more extensive models out there that don't have the same issues... I just don't know know which Excel product they were created on.
[{"id": "hxdgagf", "text": "office 365 isn't a 'product' it allows you to download those versions.  I think I have 19 on one computer and 21 on another I just upgraded.  \n\na 3mb excel is a big excel.  Whatever issues you are having probably have to do with how it is coded.\n\nNot saying ms is perfect (far from it) but if your gripe is \"my spread sheet keeps crashing\" then probably something is jacked up in it that you may want to fix.", "replies": [{"id": "hxz7p87", "text": "Do you notice any difference in issues or have a preference between 2019 and 2021?", "replies": [{"id": "hxz9gne", "text": "If they were side by side I doubt I could tell you which is which tbh.\n\nDo you have 365 now?  I dont understand if you are trying to use the website apps or have downloaded something?  You should have access too a lot of versions I think.\n\nDoes your sheet pull db data or use other plugins?  If so make sure that stuff is up to date.  I have one excel I use that pulls comp data automatically from a db through some other package and it wont run on win7.  Could be something like that too.\n\nDo your coworkers use it?  Do they have issues?  Id ask about their setups", "replies": [{"id": "hxzc88j", "text": "Okay I'm definitely going to make the switch then.\n\n&amp;#x200B;\n\nYes I have 365 now and am solely using the desktop \"program\". In regard to my models, everything is internal without any external links. \n\n&amp;#x200B;\n\nYes coworkers use 365 as well but no one in my office (only 7 people) use excel even remotely to the extent that I do...\n\nInteresting note. I updated from windows 10 home to windows 11 pro last week. Definitely noticed a significant difference in lagging / RAM usage.", "replies": [], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "hxgku0x", "text": "I have \"big data\" excel files that are 50MB+ and while they can take a long time to calc with the formula ranges, it's not crash prone in the way you describe. 3MB does sound pretty big for a waterfall model, though.  Is it an older model that has been passed down for a long while?  If so, I've found copying and pasting each tab's data into a new file and getting that wired up can help get away from instability if the same file is crash prone across computers.  Try starting with a clean WB and move what you need over to it.  Some of the ones I've had issues with originated in the early 2000s and were just modified over and over which can create issues.  Externally linked workbooks might be another cause.", "replies": [{"id": "hxz7es0", "text": "The model has everything, not just a waterfall. I've taken every precaution possible, from starting clean to limited all line items to 25 years, etc. Do you use 365 or 2019/2021?", "replies": [{"id": "hxzob86", "text": "365 with build from the enterprise channel\n\nAny macros that run on cell change?", "replies": [{"id": "hy3sljp", "text": "Nope... way too scared to see what would happen if I did", "replies": [], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}]