[Year 12 IT Apps] Bad, Excel. Bad!

[Meadows, Roslyn M]

Or you can cancel error checking all together 

Go to Tools - Error Checking - Options - and uncheck the Enable
background error checking Box (there are several ways to get to this box
- this is just one of them) VOILA! Excel will no longer check for errors
or "correct" them!

Cheers

	 Roslyn Meadows
Bentleigh Secondary College
9579 1044
0412 614 062	
-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Alex Hopkins
Sent: Monday, 15 October 2007 3:22 PM
To: 'Year 12 IT Applications Teachers' Mailing List'
Subject: RE: [Year 12 IT Apps] Bad, Excel. Bad!

Hi Mark,

Excel's ability to "help" those of us who do not ask for it is weird and
troublesome.  Had you not brought my attention to this particular
example, I
wonder whether I'd ever have noticed it.  Pity help those who enter data
and
don't notice what Excel does to "correct" us.  Similar with the flagging
of
"errors" to formulas because it doesn't like different formulas in
adjacent
cells, at times.

In this instance, the way to handle this "help" is to use the Tools >
Options menu path, then on the edit tab, clear the "Extend data range
formats and formulas" check box.

Dr Alex Hopkins
Bayside Christian College

-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au]
On Behalf Of Mark Kelly
Sent: Monday, 15 October 2007 2:50 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] Bad, Excel. Bad!

A curious problem with Excel.  Please play with the attached file.

It seems Excel thinks it knows better than I do about what formulas 
should be, and I can't work how how to stop it.  Something to do with 
its 'advanced formula error' fixing, I guess.  Very annoying!

To try it out, just put "1" into each of the shaded cells and watch what

happens to the formula for the total of section A!

Any ideas for fixes?

TIA
Mark

-- 
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000
School Fax +613 95789253
kel AT mckinnonsc.vic.edu.au

Webmaster - http://www.mckinnonsc.vic.edu.au
IT Lecture notes: http://vceit.com
Moderator: IT Applications Mailing List

You'll know when we are officially a civilised race: our schools have 
all the money they need and the Air Force has to run a chook raffle to 
buy a new bomber.
_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au  - VITTA Victorian Information Technology
Teachers
Association Inc

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au  - VITTA Victorian Information Technology
Teachers Association Inc

Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.