EXCEL people help!!

[TheIncredibles!]

AHHHHH! 35+ year spreadsheet user here and suddenly @Sum is a dead function on my spreadsheets. I have to =sum to get the formula going. WHY??? What happened? What did I do???? I cannot seem to word my google search in a way to have this fix come up - lol

 

[WDWEPCOT]

I feel your pain went through it last week I have to retrain myself to use =
Now after 40 yrs of using @Sum so mad my I.T. Person doesn’t understand my frustration

 

[lanejudy]

@ still works for me... but maybe I'm working on an older(?) version of Excel:
Microsoft® Excel® for Microsoft 365 MSO (Version 2302 Build 16.0.16130.20806) 32-bit

 

[MGMmjl]

This may be of some help:

https://techcommunity.microsoft.com/t5/excel/sum-not-working/m-p/3995775

I've always used = and not @ in my formulas, so I'm not familiar with using it. But it sounds like from that thread, it may be due to a recent update.



One response says: "@SUM() works if you ON Lotus compatibility setting (OFF by default) here"

 

[lovesmurfs]

@Sum (actually, any formula with the @ symbol) is a holder from Lotus 1-2-3 (ah, good times).

I've been impressed they kept it this long. Still works for me, so maybe PP's solution might help for you. Best wishes!

 

[TheIncredibles!]

@Sum (actually, any formula with the @ symbol) is a holder from Lotus 1-2-3 (ah, good times).

I've been impressed they kept it this long. Still works for me, so maybe PP's solution might help for you. Best wishes!

/ir /ic

still use those

 

[lovesmurfs]

Oh, the backslashes! All pre-mouse.

 

[TheIncredibles!]

WYSIWYG anybody? I predate that also. You could use most of a ream of paper trying to format one small spreadsheet when you couldn’t even see the results of your formatting on the screen

 

[SueInBoston]

At work, we had to do a workaround with an API call from command line. over half of the users didn't know what the command prompt was and keep forgetting. I finally did a small .exe file for them to run from Windows Explorer.

 

[ElevationNotice]

The Incredibles

 

[Cogswel_Cogs]

I don't understand why you would have kept writing it?
I started in 123 and once I could stop doing pointless characters I jumped at the chance.

I still marvel how most of the stuff that's easier to do today was still available back then with sumproduct and some other well designed formulas.

 

[TheIncredibles!]

I don't understand why you would have kept writing it?
I started in 123 and once I could stop doing pointless characters I jumped at the chance.

I still marvel how most of the stuff that's easier to do today was still available back then with sumproduct and some other well designed formulas.

Habit? Old dog, new tricks? I had to learn how to function without a mouse so sometimes it's still easier without one?

I really think today's youth has no clue how spoiled they are never having to work without a mouse.

 

[_19disnA]

I find it best to pick a product and avoid the constant updates. Mostly the updates are just to generate revenue and add seldom used features most never use. Honestly who needs 300 different fonts? 90% of the features in most spreadsheet programs are for things I never use and likely that way for most people. I don't run a business from it or have 100,000 records in some database to keep track of. I found a free version online from some other company a few years ago and have been very happy with it. I can't recall them ever making any updates which is fine by me. I use it mostly for a few basic spreadsheet functions like math or perhaps some graphs.

 

[disneychrista]

It’s always been =sum in excel as far back as I’ve been using it, about 25 years.

 

[PollyannaMom]

I've always used the equal sign, but I feel your pain!! DH and I have been running up against random changes since the last update as well.

I can embrace change when I have a reason and an explanation; this out-of-the-blue stuff drives me nuts!

 

[TheIncredibles!]

This may be of some help:

https://techcommunity.microsoft.com/t5/excel/sum-not-working/m-p/3995775

I've always used = and not @ in my formulas, so I'm not familiar with using it. But it sounds like from that thread, it may be due to a recent update.

View attachment 818918

One response says: "@SUM() works if you ON Lotus compatibility setting (OFF by default) here"

THIS WORKED!!!!! Thank you

 

[Cogswel_Cogs]

The new update is adding more security to my macros.
I now have to walk people through making a trusted location. It's not to bad at first I thought I was going to have to digital sign everything, which to this day I have yet to figure out how to do properly.

 

[TheIncredibles!]

It’s always been =sum in excel as far back as I’ve been using it, about 25 years.

I know but many of us predate that and using a mouse in a spreadsheet. They carried over the keystrokes that have been ingrained in so many of us now aging population

 

[lovesmurfs]

I know but many of us predate that and using a mouse in a spreadsheet. They carried over the keystrokes that have been ingrained in so many of us now aging population

I fought the mouse as long as I could. In the early 90s I was a hotel secretary and had a lot of Word Perfect macros that went keystroke by keystroke to write letters and contracts -- it was so cool that it would stop as I typed where it needed to be personalized, and then continued on when I hit Enter.

The advent of the mouse changed that philosophy, and rather keystroke by keystroke, it was the final outcome that macros did. I went kicking and screaming into Microsoft Word.

I'm FINALLY trying not to double space after periods and colons. I hate change.

 

[TheIncredibles!]

THIS WORKED!!!!! Thank you

Never mind that just created other issues . Oh well