i am using Excel 2007 for displaying results of various queries i get from TOAD/Oracle. suddendly it dawned on me that the Auto Calculations on the bottom status bar are not working, although everything that should be ticked is ticked and configured.
when writing arbitrary numbers in ANOTHER new sheet (of the same document) and selecting the corresponding cells, the sum is displayed and is correct
I spent a frustrating hour searching everywhere why is that happening, enabling/disabling add-ons and options and decided to ask a question here.
I came to the conclusion that something is definitely wrong with the FORMAT of the data in the cells, or the way TOAD exports them.