Hi Vijay_India,

Not sure if you meant how did I break it, or how did I fix it, but assuming
the latter as I don't think I will ever know how it got broken.

All i meant by Detect and Repair is you click on the Help Menu inside Excel
and select the option off there called 'Detect and Repair'. It then goes away
and magically resets everything presumably back to the install time.

Don't think that has any real security implications, so not too sure what
you mean by that. The Detect and Repair did not report anything as it went
along it just went away and presumably just did a sort of restore process. I
suppose though if it happened once it could happen again. We do become too
dependent on these things and assume that they are always right. Best to be
certain and check and double check I guess.

"Vijay_India" wrote:

How did you do that? Probably everyone will get to know the security side of
excel now.

"knowq.biz/video.htm" wrote:

Finally cracked it - I needed to run Detect and Repair and the Sum
functionality magically starts working again. Pretty scary stuff, no warnings
nothing just failing to get the right results from basic SUM function. Will
never rely on Formulae just being right now without double and triple
checking at least some of them. Let the Excel User beware........

"knowq.biz/video.htm" wrote:

I have just opened a spreadsheet and tried changing data in my C Column but
noticed the results of the SUM formula did not change. I pressed recalculate
F9 and still no change. Suspect some update has broken the SUM functionality
- looks pretty serious to me. Can anyone enlighten me as to how to fix the
SUM problem, also makes me wonder what other fundamental formulae are now no
longer working. Loads of business depend on Excel data, and I would have
thought the Sum functionality pretty basic. Makes me wonder what business
decisions are being made today on the strength of spreadsheets that have out
of date SUM values bearing no relation to the data that is summed by the SUM.
I know there was an issue with spreadsheets created in other versions of
Office or something, but I have just created a new spreadsheet and the SUM
does not SUM. Am I missing something here?