Forum Discussion
@SUM not working
I learned Excel waaaay back. I have always typed in my formulas as @SUM and not =SUM. For some reason the @ version is not currently working. Did Microsoft phase this out? I can't find anything o...
This solution does not work. I guess I am also ancient in age as I've ALWAYS used the @sum. It is such a habit for me that this all of a sudden not working is extremely annoying!
Never mind - closed my sheet, re-opened, tried it and it DOES work. Thank you! (too bad it won't stick and I have to remember to do this everytime tho).
DebraP I feel your pain. I began using Lotus123 in the 80's and have always used the @ symbol in excel (and I am somewhat of a master at excel, so no dummy). the @ symbol stopped working for me around a week ago, after another company installation of cloud based Thompson Reuters app, requiring 2FA and update to my MS account. Not only can I not use @, my CTRL/spacebar no longer highlights sections of data before encountering a blank row/column. There are a few other oddities that have not worked but they have been hit and miss and depends on which workbook I am in. It is sooooo frustrating. I cannot type =sum or anyother =formula, my fingers do not work that way!!! No one out there seems to notice as we are too old I guess and very few of us operate this way with @. Its my left hand that moves to hit @ as I'm whizzing thru typing, I cannot make my right hand find =. If I have to retrain my hands I am going to be VERY VERY UNHAPPY! and this still doesnt solve the CTRL/spacebar issue. Turning on the Lotus123 transition box has to be done for each different workbook. Oh how I am not going to do this. It has not been an issue for 40 years, why now??? Hope someone can come up with something or at least a reason why this just started occuring.
- I feel you. The equal sign is a very odd and uncertain reach, however Microsoft has never cared about my opinion.
IKR? I do believe my IT dept my have found a cause tho, not certain. I work in and outside of our 2 servers and thus utilize various versions of excel depending on where I am working. The major problems are stemming from version 2311 Build 17029.20108 which I believe I just upgraded to a week or so ago which is when my issues began. Another version I work on, version 2302 build 16130.20846, has some new weirdness to it but the @ works as well as SHFT/spacebar, up/down arrows.
Just something to consider as we are thinking there are a few bugs in version 2311 MS needs to work out and then hopefully things will be back to normal for us old timers. LOL
