PIVOT TABLE AND (MORE GENERALLY) MICROSOFT OFFICE PROBLEM

Excel has something new which is called Data types. Currently only two types exist: Geography or Stocks data type. With the Geography and Stock data type you really pull in a lot of data into a single cell. To get individual fields from such a cell you type =E2.Population to get the number of people in a country (for instance).
The syntax e2.e32 actually means that you want to get a field named "e32" from a data type in cell E2. Because there is no such field in cell E2 (and because cell E2 does not have a data type assigned to it), you get a #FIELD error. Fix this by using =SUM(E2:E32)

ALso you wrote that "Today suddenly all my Excel financial files switched to pivot table". Can you perhaps show us a screen-shot of what you mean?