Tip From a Reader: Link a Single Excel Cell Into a Word Document

BY STANLEY ZAROWIN

Tom Glogau, a CPA with Grove, Mueller & Swank PC in Salem, Ore., wrote me that he has no trouble linking an Excel file to a Word document. But he was initially baffled when he tried to do the same thing with just a single cell from a worksheet. Copying the cell and clicking on Edit, Paste Special and selecting Microsoft Excel Worksheet Object and selecting Paste link didn’t work because the data wouldn’t line up properly. ( Note: This applies to Office 2003. In Office 2007, Paste Special is under the Clipboard section of the Ribbon, or you could use the shortcut Ctrl + Alt + V, which will take you directly to the window displayed below. The remaining steps are the same in both versions.)

 

But with some experimenting, he discovered it can be done easily by copying the cell, going to Word, placing the cursor at the target insertion point, clicking on Edit, Paste Special and then selecting either Unformatted Unicode Text or just Unformatted Text (instead of Microsoft Office Excel Worksheet Object) and then clicking Paste link and OK (see screenshot below).

 

Now, when the cell value changes in the Excel spreadsheet, it will also update in the Word document the next time it is opened. ( Note: For this feature to work, ensure automatic updating is enabled in Word. Go to Word Options, Advanced and scroll down to the General settings. Be sure there is a check next to Update automatic links at open.)

 

More from the JofA:

 

 Find us on Facebook      Follow us on Twitter

 

SPONSORED REPORT

8 accounting and auditing issues you can’t afford to ignore

Download this sponsored report for an overview of some of the most important developments accountants and auditors are facing today.

DOWNLOAD

Filing season quick guide — Tax year 2014

Tax season started Jan. 20. Download our “quick guide,” a printable card that contains dollar thresholds, tax tables, standard amounts, credits, and deductions to keep at your fingertips during tax season.

TAX NEWS

Expired tax provisions extended for 2014

President Barack Obama signed legislation that retroactively extended more than 50 expired tax provisions for 2014, allowing taxpayers to take advantage of a host of tax incentives during this filing season.