pivot table problem
3 Topicssummarize values by sum in Pivot table not working
working in pivot table and summarize values by sum is not working (the output is "0"), whilst summarizing by count gives an output of "682185"; this as the table is having so many lines. Any idea how to solve the issue so I have the values by sum?93KViews0likes14CommentsPIVOT TABLE AND (MORE GENERALLY) MICROSOFT OFFICE PROBLEM
PIVOT TABLE (AND OFFICE) PROBLEM Today suddenly all my Excel financial files switched to pivot tables, and when I open Word to write this memo the top is different than before: top line is AutoSave followed by 5 symbols unfamiliar to me. I’ve used Office for decades and never had such a change before. With pivot tables I can no longer sum a series of numbers in a column, for example =sum(e1.e32) If I try this I get #FIELD! which is meaningless to me. And I can no longer put a comment on a cell with a red marker in the upper right hand corner of the cell. I don’t see how I could have unwittingly made this change in Office, both to Excel and Word – can you help? Have I somehow been hacked? I’m Robert Valtz, in France. I’d be happy to give someone on-line access to my computer, a Dell Latitude 7280.871Views0likes1Comment