A Word of Caution

BY STANLEY ZAROWIN


A red flag went up when CPA Henry G. Barcomb Jr., audit manager at Schunk, Wilson & Co., Amherst, N.Y., read this sentence in the Technology Workshop article “Links in a Blink,JofA, Nov. 06, page 68: ‘‘[O]nce you invest the time to create a (link) connection, you never have to do it again: It functions instantly for the life of the file without further prompting.” While the statement is true, he acknowledges, he added this caution: Spreadsheet linking, while powerful, can cause problems if not done properly. For instance, if you insert or delete columns or rows in a source file without first opening the dependent files, your links are no longer valid. The link is not removed per se, it just no longer links to the original data in the source file. This can produce errors in the dependent files.

The solution: Create separate link sheets that reference cells in the source sheets. Barcomb also suggests including descriptions of which sheets and cells are being referenced in the source file and which are being linked in the dependent files. So when data in a source sheet is changed, the cell references on the link sheet automatically change as well, but the link from the dependent file to the link sheet remains unchanged. The descriptions quickly identify which files are dependent on the data in this source file.

SPONSORED REPORT

How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

QUIZ

News quiz: Scam email plagues tax professionals—again

Even as the IRS reported on success in reducing tax return identity theft in the 2016 season, the Service also warned tax professionals about yet another email phishing scam. See how much you know about recent news with this short quiz.