Forum Discussion
Margot Rylah
Jun 10, 2018Copper Contributor
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...
barrymdho
Jan 25, 2021Copper Contributor
alphamanny , I think we addressed the formatting issue, where many had formatted to number or currency, where the auto sum still did not work. In my case, I had formatted to number or currency and still the auto sum would not work, until I copy pasted into MS Word, cleared all formatting, then pasted back into Excel. FYI
Erik_Schroder
Mar 03, 2021Copper Contributor
barrymdho
Is this the only solution ie copying the values from xcel and then pasting them in .doc and repeat the process to excel? I tried other options but this is the only one which works......