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...
After much experimenting, I found that downloading bank data "infected" the cells, including ones that look blank. In general, they "push" the Sum results down to below the last cell that is not empty or not infected, or some similar effect. Changing the format has no effect. Selecting infected cells then clicking delete removes the infection.
Hopefully you can at least partially understand my cryptic diagram.