Excel Err Msg: Unable to Paste Link

 Last reviewed: November 2, 1994
Article ID: Q74171

SUMMARY

You may receive the error message "Unable to Paste Link" when working in Excel. Generally, this message means that Excel cannot paste a link using the type of information that is currently in the Clipboard. The message may also appear if the Clipboard contains too much information for Excel to put in a cell.

MORE INFORMATION

In Excel, formulas are limited to 255 characters. It is common for users of Microsoft Q+E for Excel to attempt to copy and paste SQL queries from Q+E that exceed this limit, causing the above error message.

Steps to Reproduce Problem

  1. Create a long query in Q+E by adding 7 or 8 conditions.

  2. From the Q+E Edit menu, choose Copy Special.

  3. Select the SQL Text option under Link Formula.

  4. In Excel, choose Paste Link from the Edit menu.

Workarounds

  1. In Q+E, when you choose Copy Special, select the Query Name option rather than SQL Text.

    -or-

  2. Use Copy instead of Copy Special from the Edit menu in Q+E.

    -or-

  3. Restructure your query so that it is within Excel's limit yet returns the same information. For example, use Greater or Equal, rather than Greater than and Equal joined with OR.

For more information on structuring SQL queries, please see pages 11-20 of the "Q+E for Microsoft Excel User's Guide" for version 3.0.

REFERENCES

"Q+E for Microsoft Excel User's Guide." Version 3.0, pages 50-52.

"Microsoft Excel User's Guide," Version 3.0, page 307-324.

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.