Crosstab Doesn't Use Database Defined in Active Worksheet

 Last reviewed: February 15, 1997
Article ID: Q102014
The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0, 4.0a

SYMPTOMS

In Microsoft Excel version 4.0, when you use Crosstab ReportWizard, the current database may be ignored when an external database has been previously defined with the Q+E add-in macro (QE.XLA).

CAUSE

When you use the external database option to define a database, the following hidden names are created on your worksheet: 

    This name     Refers to this
    ---------------------------------------------------------------

    cursource      The file type (dBASEfile, TextFile, or ExcelFile).

    int_ext_sel    Whether an internal or external database
                   has been selected and returns the number one (1) or
                   two (2) respectively.

    opendbs        The full path and filename of the defined database file.
The Crosstab Wizard will use the database defined by the hidden name "opendbs". When the database is redefined when QE.XLA is not open, the hidden name will not be updated to reflect the database change.

WORKAROUND

To work around this situation:

  1. Open the QE.XLA add-in file.

  2. Select all the cells on the worksheet in the database range, including the field names.

  3. From the Data Menu choose Set Database, select the Current Selection option and choose OK.

REFERENCES

"Q+E for Microsoft Excel User's Guide", pages 58-60

KBCategory: kbusage
KBSubcategory:

Additional reference words: 4.00 4.00a wizard



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: February 15, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.