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

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.

COLUMN

Deflecting clients’ requests for defense and indemnity

Client requests for defense and indemnity by the CPA firm are on the rise. Requests for such clauses are unnecessary and unfair, and, in some cases, are unenforceable.