Nel post
*Lynda* ha scritto:

We have a spreadsheet with the usual numbers to be added (eg:
=SUM(A2:A59)with the total showing in cell A60.The problem we are
having is when we double click in the total cell (A60) the total
turns to 0. I have checked the calculation tab in the tools options
and it is set on auto. We cannot understand when there is a number
there eg: $8512.30 and we double click in the cell to check our
formula it changes to $0.00 and the only way you can get your number
back is via the undo button.


Hi Lynda,

Check if you have an event macro that do the job...


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy