Re: Spreadsheet SUM(C:C) or indeed any SUM no longer works Excel 2

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Well that looks like the case Bob, but it does make me wonder what in fact
that was, and if I can inadvertently do this, then presumably there may be
others out there that can also.

What would have been nice though would have been to have been given some
indication that something was amiss when I first opened the spreadsheet
before I had noticed the fault.

What would have been even more useful would have been for the detect and
repair to report on the most likely cause of the missing registry keys or
whatever, or at least to tell me not to do whatever it was I was supposed to
have done again. If I was told what was missing it would have maybe been of
use for future.

Unfortunately since it is now fixed there will probably be absolutely no way
of finding out exactly what the mystery cause was. Oh well!

"Bob Phillips" wrote:

Looking at help, it says ...

a.. This procedure detects and repairs problems such as missing files and
registry settings associated with all installed Microsoft Office programs.
It will not repair personal files, such as spreadsheets or documents.

.... so it sounds as though you (maybe inadvertently) did something that
messed up Office.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"knowq.biz/video.htm" <knowqbizvideohtm@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:D948B76D-E2E2-479E-8B40-2608E30D5351@xxxxxxxxxxxxxxxx
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?



.

Relevant Pages

  • Re: Thanks to Doug @ Kansas Pinball
    ... Just wanted to give a shout out to say thanks to Doug @ Kansas Pinball ... offered to repair mine, and at only the cost of the parts...he offered ... Bob in HB ... I got rid of the solder blob and looked for anything else. ...
    (rec.games.pinball)
  • RE: Error clearing ARP cache
    ... Bob what is the exact command for clearing the ARP cache. ... When trying to do a repair of the network connection I ...
    (microsoft.public.windowsxp.network_web)
  • RE: subforms
    ... Yes Bob they are. ... I had repair, maintenance, monitor acitivity logs all in ... one Remedial Table but split the logs into subforms because sometimes one has ... maint record to a repair record etc rather than the next main record. ...
    (microsoft.public.access.forms)
  • Re: csc.exe application error
    ... "Bob H" wrote: ... If still no joy try Repair /Install, you will not lose any data, but it ... well I already had process explorer installed and didn't think ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: HKEY_LOCAL_MACHINE problem
    ... High Priority: Highlighted value is missing or invalid: ... Restarts often bring up an OS failure, although the automatic repair function takes the computer back to the same slow performing system. ...
    (microsoft.public.windows.vista.performance_maintenance)