Microsoft KB Archive/102014

From BetaArchive Wiki


Crosstab Doesn't Use Database Defined in Active Worksheet

Last reviewed: April 29, 1998
Article ID: Q102014

4.00 4.00a WINDOWS kbusage 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
Keywords : kbusage
Version : 4.00 4.00a
Platform : WINDOWS


Last reviewed: April 29, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.