Specifications

58 RSLinx – Training Guide

5. In the Columns per Row box leave it at the default value of 1. This will format the

block of data to be placed in one column in the destination application which is

Microsoft Excel in this case

6. Pick the topic you have configured, TESTSOL, which is displayed in the Select a

Topic box.

7. Click OK. All of the information required to establish a Hot Link to Excel is now

residing in the Windows clipboard.

8. Start-up Microsoft Excel by clicking the taskbar’s Start button/ Programs/Microsoft

Excel, but DO NOT CLOSE RSLinx.

9. Place the cell pointer in the cell that you would like the Hot Link to be put in. For

example, place the cell pointer in cell A1 by RIGHT-clicking on that cell.

10. Select Paste Special, source of Paste Link and click on OK. The Hot Link will be

pasted into the cell and data from the PLC will appear.

• The five timer accumulator values will begin to update in five successive cells.

This is now live data being read directly from the PLC-5.

Excel’s Paste Link command pastes

the Hot Link co

ied from RSLinx.