Link A Word Document To Excel Data

BY STANLEY ZAROWIN

Key to Instructions
To help readers follow the instructions in this article, we used two different typefaces:
Boldface type is used to identify the names of icons, agendas and URLs.
Sans serif type indicates the names of files and the names of commands and instructions users should type into the computer.
  Q. I often make presentations based on last-minute sales data. It gets really wild when I have to copy last-minute numbers from the spreadsheet and quickly drop them into a Word document for the presentation. I sure hope there’s a better way.

A. There is, and it’s fast and simple. I’ll show you how to dynamically link the Excel spreadsheet to your Word document so that when you make any change in the spreadsheet it instantly and automatically will appear in the document. Caveat: Both the spreadsheet and the document must be in the same folder (subdivision).

Begin by highlighting the range of cells (A1 to D4) you want displayed in the document and copy it (Ctrl+C).

Now go to the Word document, place your cursor where you want the copied cells to go and click on Edit, Paste Special. When the Paste Special dialog box opens, select the radio button labeled Paste link , click on Microsoft Excel Worksheet Object and on OK .

Now any changes you make in the worksheet (from A1 to D4) also will appear in the Word document.

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.