Forum Discussion
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...
I just encountered this too.
I am using Auto Sum to look at cells that have already Auto Summed several other cells. I already checked and each one is set to currency. The cell range is correct, J113:J116. And my total to remit is $0, or $55,000+ but should be $62,725.
Accountants get cranky when AUTO SUM DOESN'T WORK. How do you even explain that to the Board of Directors? Oh, sorry guys, Excel doesn't work anymore. It's ok. I still have my trusty TI-5320SV CALCULATOR.
Technically this file is from before I subscribed to Office 365, but the format was original .xlsx and there doesn't seem to be an option for Office 365 formatting. Honestly, that shouldn't matter. Excel should always be able to take into account old formatting or pop up a message about it like it did at the last big programming change.
Side note - Someone suggested that the Auto Sum button on the ribbon shouldn't be used which is bogus. It's there to be used.
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!
Meg0422 I did everything listed in this chat and my autosum is still not working in every column
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
