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

Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.

QUIZ

News quiz: IRS warning on cyberattacks and a change in pension rules

Once again, the IRS sounds the alarm about a threat from cyberthieves. See how much you know about this and other recent news with this short quiz.

CHECKLIST

Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.