Microsoft KB Archive/102014: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 33: | Line 33: | ||
opendbs The full path and filename of the defined database file. | opendbs The full path and filename of the defined database file. | ||
</pre> | </pre> | ||
The Crosstab Wizard will use the database defined by the hidden name | 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 == | == WORKAROUND == | ||
Line 44: | Line 44: | ||
== REFERENCES == | == REFERENCES == | ||
"Q+E for Microsoft Excel User's Guide", pages 58-60 | |||
|} | |} | ||
Latest revision as of 09:23, 20 July 2020
Crosstab Doesn't Use Database Defined in Active WorksheetLast reviewed: April 29, 1998 |
4.00 4.00a WINDOWS kbusage The information in this article applies to:
SYMPTOMSIn 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). CAUSEWhen 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. WORKAROUNDTo work around this situation:
REFERENCES"Q+E for Microsoft Excel User's Guide", pages 58-60 |
KBCategory: kbusage Last reviewed: April 29, 1998 |