Microsoft KB Archive/76243

{| = Paste Link a Single Record to a Range in Excel from Q+E =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q76243

SUMMARY
If you paste link to Excel a single field of a query containing only one record from Q+E, the entire highlighted range will fill with that record.

This is be design; however, it may cause problems for you if you depend on the link to update when new records are added that match your criteria.

Workaround
Change the link formula in Excel to &quot;ALL&quot;:

 Select cell A1 in Excel.  Change the existing link formula to: =QE|Query1!ALL  Hold down the CTRL and SHIFT keys before pressing the ENTER key to enter the formula as an array. The same record will still be displayed in each cell of the range as long as only one record matches the conditions specified in the query; however, when new records are added at this same location, they will be displayed in Excel.

Steps to Reproduce Problem
 In Q+E, open the example file EMP.DBF from the QE subdirectory. Select &quot;R2C3,&quot; which should contain &quot;L04&quot;. From the Select menu, choose Add Condition and choose the OK button. This should leave only one record displayed.</li> Select &quot;R1C3.&quot;</li> From the Edit menu, choose Copy.</li> In Excel, highlight A1:A10.</li> From the Edit menu, choose Paste Link.</li>  The range A1:A10 will display &quot;L04&quot; in each cell. The formula bar will display: {=QE|Query1!'R1C3:R1C3'} </li></ol>

If you now add new records to DEPT.DBF so that you have more than one record with the location &quot;L04&quot;, they would not be displayed in Excel because your current link refers only to a single cell.