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

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.

TAX PRACTICE CORNER

More R&D tax help

"Can I use the R&D credit?" PATH Act enhancements make the credit more attractive to a wider range of taxpayers.

QUIZ

News quiz: Tax-related data breach explained

News about a data breach that affected about 100,000 people, the IRS’s budget for the fiscal year, and the 2018 health spending account limits received attention recently. See how much you know with this short quiz.