Forum Discussion

Copper Contributor

Jun 10, 2018

AutoSum not working

I've been using Excel with AutoSum for many years. Recently installed Office 365 and pre-existing spreadsheets are working as usual. Have just set up a brand new spreadsheet with lots of cells to a...

Formulas and Functions

barrymdho

Copper Contributor

Aug 20, 2020

kgal805

I had the same issue with AutoSum not working and all of these solutions not working. It appeared that some imbedded formatting of the cells would not disassociate from these cells in spite of reformatting them every way possible, such as General, Text, Numbers, Currency etc.

I finally found a solution, as I realized that Excel does not have the same "Paste Special" options aw MS Word, specifically the "Unformatted Text" option. By simply "copying" the column of numbers I wanted to AutoSum into MS Word, and "pasting" them using the "Paste Special" option, then selecting the "Unformatted Text" into the word document, then copying them and pasting them back into Excel, the AutoSum worked.

Essentially, pasting in Word as Unformatted Text discards the hidden formatting that Excel misses when formatting cells. Yay! Solution found!

Barry

jdlopes

Copper Contributor

Jan 16, 2021

barrymdho Success! It worked, but we shouldn't have to go through all that to autosum!