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.
MORE INFORMATION
Workaround
Change the link formula in Excel to "ALL":
- 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 "R2C3," which should contain "L04".
- From the Select menu, choose Add Condition and choose the OK
button. This should leave only one record displayed.
- Select "R1C3."
- From the Edit menu, choose Copy.
- In Excel, highlight A1:A10.
- From the Edit menu, choose Paste Link.
- The range A1:A10 will display "L04" in each cell. The formula bar
will display:
{=QE|Query1!'R1C3:R1C3'}
If you now add new records to DEPT.DBF so that you have more than
one record with the location "L04", they would not be displayed in
Excel because your current link refers only to a single cell.
REFERENCES
"Q+E for Microsoft Excel User's Guide," pages 50-52
|