Out, Out, Green Triangles

BY STANLEY ZAROWIN

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 tab and unchecking the Enable background error checking . Then click on OK .

SPONSORED REPORT

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: IRS enforcement, a hot job, and audit value

The IRS’s 2016 Data Book, a “hot job” of particular interest at this time of year, and insight into how executive and audit committees view the insights from financial statement audits received attention recently. See how much you know with this short quiz.