Link A Word Document To Excel Data


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.


Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.


News quiz: Retirement planning, tax practice, and fraud risk

Recent reports focused on a survey that gauges the worries about retirement among CPA financial planners’ clients, a suit that affects tax practitioners, and a guide that offers advice on fraud risk. See how much you know with this short quiz.


Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.