Forum Discussion

Margot Rylah's avatar
Margot Rylah
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
Meg0422's avatar
Meg0422
Copper Contributor
Aug 16, 2019

Meg0422 

Replying to myself for future readers:

 

I saved and closed Excel.  When I re-opened it popped up a message that there was a circular reference.  Once I fixed it, the Auto Sum worked.

 

 

Phew!

kgal805's avatar
kgal805
Copper Contributor
Jun 25, 2020

Meg0422 I did everything listed in this chat and my autosum is still not working in every column

 

  • barrymdho's avatar
    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's avatar
      jdlopes
      Copper Contributor
      Jan 16, 2021

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

Resources