Hidden properties for visible objects in Microsoft Excel 2000 are listed in the following table. No methods have been hidden. Most of the hidden properties have been replaced by new Excel functionality. These properties are supported only for backward compatibility; for new code, you should use the replacement functionality provided in Microsoft Excel 2000.
| Objects | Hidden property | Replacement |
|---|---|---|
| Application | UILanguage | LanguagePreferredForEditing |
| PivotCache, QueryTable | Sql | CommandText |
| QueryTable | TablesOnlyFromHTML | WebSelectionType |