DDE Link to Q+E Truncated by Excel

Last reviewed: November 2, 1994
Article ID: Q66435

SUMMARY

Microsoft Excel for Windows has a limit of 128 characters for the item (application name) and the topic in a DDE link. If you enter a link with either an item or a topic longer than 128 characters, Excel will truncate it.

MORE INFORMATION

When you use the Copy and Paste Link commands to copy and paste SQL text from Q+E to Excel, the item or topic in the link created may be longer than 128 characters. The formula will be truncated by Excel, but the data will display and update correctly.

If you attempt to enter the link formula in Excel or modify a pasted link when the item or topic portions are longer than 128 characters, Excel will truncate the link and display an error message.

For example, if the following is entered into a cell in Excel 2.00, 2.01, 2.10, 2.10c, and 2.10d

   =QE|'SELECT FIRST_NAME, LAST_NAME, EMP_ID, HIRE_DATE, SALARY,
    DEPT, EXEMPT, INTERESTS FROM dBASEFile|D:\WINAPPS\QE\QE250\EMP.DBF
    WHERE HIRE_DATE > {06/01/80} AND SALARY > 27000.00'!ALL

the result after pressing ENTER would be:

   =QE|'SELECT FIRST_NAME, LAST_NAME, EMP_ID,HIRE_DATE, SALARY,
   DEPT, EXEMPT, INTERESTS FROM dBASEFile|D:\WINAPPS\QE\QE250\EMP.DBF
   WHERE HIRE_DATE > {06'!ALL

WORKAROUNDS

First Workaround

  1. Create a shorter query.

  2. Reduce the desired fields and conditions in the query.

Second Workaround

  1. Link to a query file.

  2. In Q+E, create a query with the desired fields and conditions selected.

  3. From the File menu, choose Save As and give the file a query name other than QUERY# (where "#" is a number). This will prevent confusion with future queries with the same names.

  4. If the link is already established in Excel, replace the SELECT statement in the Excel formula with the name of the QUERY FILE. For example:

          =QE| |test.qef!ALL
    

  5. If the link has not yet been established in Excel, do the following:

    a. From the Edit menu, choose Copy Special. b. For the Link Formula option, select Query Name rather than

          SQL text.
    
    c. Select either Entire or Selected Area rather than SQL text. This

          will reduce the size of the topic text in the link in Excel.
    

  6. Return to Excel.

  7. From the Edit menu, choose Paste, then Paste Link to establish the DDE link with the saved Query file in Q+E.


KBCategory: kbother
KBSubcategory:

Additional reference words: noupd


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.