Save or Print Is Slow After a Join in Q+E

Last reviewed: November 2, 1994
Article ID: Q72012

SUMMARY

After using the Select Join or Select Outer Join command in Q+E, the first time you use the Print or Save command may take a relatively long time to execute. Once a Print or Save command has been executed, the next one will execute much faster. You may also find that going to the end of the joined file will take a relatively long time the first time it is attempted.

MORE INFORMATION

This feature of Q+E is designed to make reviewing the results of the Select Join or Select Outer Join command faster. When the command is selected, Q+E joins only the first few windows of information, so you can quickly see an example of the results. If you want to see more windows of information, Q+E joins that portion. If the resulting joined file appears correct, you will most likely want to print the file or save it. At this point, Q+E performs the remainder of the joining. As a result, bulk of the joining is performed when Q+E is sure that you want to keep the results of the joining.

For more information about the Select Join and Select Outer Join commands, see pages 15-18 of the "Q+E for Microsoft Excel User's Guide".


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.