Printer Friendly
The Free Library
4,485,123 articles and books
Member login
User name  
Password 
 
Join us Forgot password?

Out, out, green triangles.


Q. Some cells in my spreadsheets contain little green triangles in the upper left-hand corner (see screenshot at right), and I can't get rid of them, though sometimes--through no apparent effort on my part--they just disappear. Is my software infected with the dreaded green triangle virus?

A. No, it's not a virus. Those green triangles are Excel's way of telling you it believes the cells contain an error. Of course, sometimes Excel is wrong, but such error-flagging is a handy fail-safe function.

Why it happens: Excel 2002 and 2003 constantly work in the background scanning for possible errors. You can turn off the feature by clicking on Tools, Options and the Error Checking Testing for accurate transmission of data over a communications network or internally within the computer system. See parity checking, CRC and validate. tab and unchecking the Enable background error checking. Then click on OK.

[ILLUSTRATION OMITTED]

STANLEY ZAROWIN, a former JofA senior editor, is now a contributing editor to the magazine. His e-mail address is zarowin@mindspring.com.
COPYRIGHT 2005 American Institute of CPA's
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 2005, Gale Group. All rights reserved. Gale Group is a Thomson Corporation Company.

 Reader Opinion

Title:

Comment:



 

Article Details
Printer friendly Cite/link Email Feedback
Title Annotation:Technology Q&A
Author:Zarowin, Stanley
Publication:Journal of Accountancy
Date:Nov 1, 2005
Words:149
Previous Article:Enter several sets of numbers in one excel cell.(Technology Q&A)
Next Article:ShortOuts.(Technology Q&A)



Related Articles
Green map attack. (helping to keep green places in your town)
Use pattern-block puzzles to teach shape and area.
Australian and Canadian colour patches of World War 1--a comparison.
DODGERS' RALLY COMES UP SHORT NINTH-INNING MISCUES DOOM L.A.; ISHII'S STREAK ENDS FLORIDA 4, DODGERS 3.(Sports)
Tease your brain. (You Can Do It).(triangles and circles)
The Devil's Triangle: at Mahogany Run in St. Thomas, golfers must navigate the Caribbean version of Amen Corner.(golf)
Golden opportunity.(Real Estate)(Brief Article)(Advertisement)
Milena Dragicevic: Ibid Projects.(London)
Tease your brain.(Activites & Oddities)
FESTIVAL SEEKS PLAYWRIGHTS.(News)

Terms of use | Copyright © 2008 Farlex, Inc. | Feedback | For webmasters | Submit articles