Home > Excel Help Portal > Excel Databases

<<  (Page 1)  Previous              Next  (Page 3)  >>

Excel Databases

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses using Microsoft Excel
databases.

51. How to install or Repair Microsoft Excel Features in Excel 2000 This article describes how to install, reinstall, or remove individual features of Microsoft Excel 2000. This information is also covered in detail in Microsoft Excel 2000 Help. For instructions about how to view this information in Help, please... KB#263958. Keywords: Query, Errors, Files, Registry, Templates

 
52. How to use the AutoCorrect Options buttons in Excel With the AutoCorrect Hyperlinks button in Microsoft Excel, you can use several options that are related to the process of typing hyperlinks in a cell. Unlike the other recovery options, the AutoCorrect Hyperlinks button always appears below... KB#291357. Keywords: AutoCorrect, AutoFormat, Errors, Smart Tag, Hyperlinks, Web

 
53. DigDB Addin for Excel allows Power Excel with Ease There are many add-ins for Excel. I recently reviewed an add-in that knocked by socks off. If you are responsible for dealing with lots of data in Excel, then this is the best $49 your company will ever spend. Rush out and buy the $49 DigDB Add-In for Excel 2000-2003 or DigDB 97 for Excel 97. Check... Keywords: Add-In, Advanced Filter, AutoFilter, Criteria, Sorting, Dates, Sales, Outline, Arrays, Formulas, PivotTables, VBA, Web

 
54. How to Move Between Custom UserForms with CommandButtons When you create a project with multiple UserForms, you can use CommandButtons to move between the UserForms. This article explains how to create two UserForms and includes a sample Visual Basic for Applications macro that moves between the... KB#161521. Keywords: VBA, Macro, UserForm, Toolbar, Web

 
55. How to Place a Checkmark Next to a Menu Item If you are working with menus programmatically, you may want to add a checkmark next to a particular menu item to show the item is active. For example, when you point to Filter on the Data menu and then click AutoFilter, a checkmark is placed next... KB#161926. Keywords: AutoFilter, VBA, Macro, Object, Toolbar, Web

 
56. Macro to Count the Number of Records Returned in an AutoFiltered List This article contains a sample Microsoft Visual Basic for Applications macro ( Sub procedure) that determines how many records were returned in a list that has AutoFilter turned... KB#213275. Keywords: AutoFilter, Criteria, VBA, Macro, Web, SUBTOTAL

 
57. How to Control the AutoFilter with a Macro In Microsoft Excel, you can use the AutoFilter feature to filter a list based on simple criteria. This article contains several sample Microsoft Visual Basic for Applications macros (Sub procedures) for controlling the AutoFilter feature in... KB#141770. Keywords: AutoFilter, Criteria, VBA, Macro, Web

 
58. How to Use the "Insert Options" Button in Excel 2002 This article explains the functionality of the Insert Options button in the Excel 2002 user interface... KB#291363. Keywords: AutoCorrect, Format, Errors, Smart Tag

 
59. Error Message: ORA00923:FROM Keyword Not Found Where Expected In Microsoft Query, when you use an alias in a query to an Oracle database, and you employ an aggregate, the query does not succeed, and you receive the following error message: ORA-00923:FROM keyword not found where... KB#259347. Keywords: Query, Errors, Registry

 
60. Filter Test, AutoFilter and Hidden Rows/Columns Not shown but if Columns were hidden they will remain hidden, when filter it turned off. Show ALL in Column A, shows that the hidden rows are no longer... Keywords: AutoFilter, Web, Comments

 
61. How to create an Auto_Open Macro to Show the Data Form Dialog Box in Excel 2000 The step-by-step article shows you how to use an Auto_Open macro to select a specific sheet in a workbook and automatically display the data form dialog box. NOTE : A macro named auto_open will be run each time you manually open the workbook... KB#213624. Keywords: Criteria, VBA, Macro, Web

 
62. How to Use the VLOOKUP Function The VLOOKUP function searches for a value in the leftmost column of a table, and then returns a value in the same row from a column that you specify in the table. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column... KB#324985. Keywords: Sorting, Errors, VLOOKUP, HLOOKUP

 
63. Advanced Pivot Table Operations Thanks to Katherine who sent the question for this week's tip: I want to place a form button on a worksheet that, when clicked, will email the same worksheet to someone. To send the whole book to ask@mrexcel.com with a particular subject line, you would use this... Keywords: AutoFilter, Sorting, Sales, Command Button, VBA, Macro, Toolbar, Web, Comments

 
64. How to Control the AutoFilter with a Macro In Microsoft Excel, you can use the AutoFilter feature to filter a list based on simple criteria. This article contains several sample Microsoft Visual Basic for Applications macros ( Sub procedures) for controlling the AutoFilter feature in... KB#213628. Keywords: AutoFilter, Criteria, VBA, Macro, Web

 
65. How to Programmatically Sum Only the Visible Cells in a Range In Microsoft Excel, you can use a Microsoft Visual Basic for Applications custom function to sum only the visible cells in a range. The SUM() worksheet function totals all the cells in a range, including hidden cells. The SUBTOTAL() worksheet... KB#213313. Keywords: Advanced Filter, AutoFilter, Format, Formulas, VBA, Web, SUBTOTAL

 
66. How to Use a VBA Macro to Sum Only Visible Cells If you have a range of cells that includes hidden rows or hidden columns, Microsoft Excel does not provide an easy way to sum only the visible cells. The SUM function totals all the cells in a range, including hidden cells. The SUBTOTAL... KB#150363. Keywords: Advanced Filter, AutoFilter, Formulas, VBA, Macro, Toolbar, Web, SUBTOTAL

 
67. Page Breaks, and Inserting Blank Rows Insert Page Breaks on change in Column A, and insert blank rows on change in Column B. To prevent inserting still more lines when rerunning a check is made to see if a blank row had already been inserted -- so this can be rerun without further changes. If you want a new sheet activate the... Keywords: Sorting, Colors, Page Setup, VBA, Macro, Web, Comments

 
68. Excel: an advanced filter to extract records If you have a list of records contained in a range of cells it is possible to extract all records that meet a specified set of criterion and place them elsewhere in your workbook. For example in a list of names and personal details you could find everyone who works for a particular organisation and... Keywords: Advanced Filter, Criteria, Query, Format, VBA, Macro, DSUM

 
69. How to sort More Than Three Columns in Excel 2000 Microsoft Excel limits you to a maximum of three columns or fields when you sort a list. If you want to sort a list of more than three fields, you must sort multiple times, with three or fewer fields at a time. Also, you must sort the fields in... KB#268007. Keywords: Sorting

 
70. How to Create Yes and No Buttons for a Custom Message Box By default, the MsgBox function in a Microsoft Visual Basic for Applications procedure contains a single OK button. However, you can display other buttons in the message box. This article provides a sample Visual Basic macro that displays a... KB#213613. Keywords: VBA, Macro, Toolbar, Web

 
71. Programatically find a blank row NYARCH writes: I want to have excel copy an entire row to a new sheet based upon a cell entry. For example I have data in cells A8:AG8, I want to have Excel copy the entire row to sheet "a" if the value in H8 is "ir", and sheet "b" if the value in H8 is "RR" and not just copied, I need it copied to... Keywords: AutoFilter, Days, VBA, Macro, Web

 
72. Types of Formatting and Features Preserved in Workbook Sent as Body of HTML Email Message Microsoft Excel has the ability to send a worksheet as the body of an HTML e-mail message. This article identifies the formatting and features that are and are not preserved when a message recipient opens a worksheet in... KB#291217. Keywords: Criteria, Format, Formulas, HTML

 
73. Excel -- Data Validation Data Validation 1. Data Validation -- Introduction 2. Data Validation -- Create Dependent Lists 3. Hide Previously Used Items in a Dropdown List 4. Display Messages to the User 5. Use a List from Another Workbook 6. Validation Criteria Examples 7. Custom Validation Criteria Examples 8. Data... Keywords: Criteria, Download, Format, Errors, Formulas, Validation

 
74. How to Use the PivotTable AutoSort Feature In Microsoft Excel 97, there is a new PivotTable feature called AutoSort. This feature allows you to automatically sort a PivotTable when you create it, or when you refresh a PivotTable after you change data in the... KB#156314. Keywords: Sorting, PivotTables, Toolbar

 
75. Excel Filters -- AutoFilter Programming AutoFilter Programming A few examples of controlling AutoFilters through VBA programming. Show All Records Turn On AutoFilter Turn Off AutoFilter Hide Filter Arrows Copy Filtered Rows AutoFilter on a Protected Worksheet Count Visible Rows AutoFilter Basics Show All Records The following code shows... Keywords: AutoFilter, Errors, VBA, Macro

 
76. Using Formulas Tutorial functions With SUMIF, you don't need ot set up a criteria range. If your sum criteria is simple, you can include it in the SUMIF statement. Comparative Ratio Analysis You can use Excel formulas to compare actual data to Robert Morris Associates annual statement studies. RMA comparative ratios are... Keywords: Criteria, Ratio, Ratio Analysis, RMA, Colors, Arrays, Formulas, VBA, Links, OFFSET, DAVERAGE, DCOUNT, COUNTIF

 
77. How to hide Records with Duplicate Cell Entries in Excel 2000 This step-by-step article shows you how to use the Advanced Filter feature to hide records with duplicate cell entries in Microsoft Excel 2000. In Excel 2000, you can hide rows that contain multiple records for an individual or company.... KB#214247. Keywords: Advanced Filter, Criteria

 
78. How to Create an Index with Microsoft Query This article describes how to create indexes with Microsoft... KB#143348. Keywords: Query, Errors

 
79. Scroll Bars in Excel Keywords: Sorting, Colors, Fonts, Formulas, Web, Comments

 
80. How to use the SUBTOTAL Function with AutoFiltered Lists in Excel 2000 This article describes how to use the SUBTOTAL function with AutoFiltered lists in Microsoft Excel 2000. You can use the SUBTOTAL function to dynamically count or display other information about records in a list that has AutoFilter turned on.... KB#244789. Keywords: AutoFilter, Macro, SUBTOTAL, AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT

 
81. How to Hide Records with Duplicate Cell Entries This step-by-step article show you how to use the Advanced Filter feature to hide records with duplicate cell entries in Microsoft Excel. In Microsoft Excel, you can hide rows that contain multiple records for an individual or company.... KB#147640. Keywords: Advanced Filter, Criteria

 
82. Opening XML Files in Excel In Microsoft Excel, you can open and save Extensible Markup Language (XML) files. This article explains how XML files are displayed when opened in... KB#282161. Keywords: Sorting, XML, Format, Styles, Errors, Files, Web

 
83. Random Numbers The usual request for Random numbers is how to generate random numbers without duplicates. While these may no longer be random numbers it is a frequent request. The following will work for small sets. It might be better to do something else for larger sets because checking every previous numbers... Keywords: Sorting, Arrays, VBA, Macro, Web, Comments, CELL, OFFSET, TODAY, INDIRECT, NOW, INFO, RAND, RANDBETWEEN

 
84. How to Use a Logical AND or OR in a SUM+IF Statement in Excel In Microsoft Excel, when you use the logical functions AND and/or OR inside a SUM+IF statement to test a range for more than one condition, it may not work as expected. A nested IF statement provides this functionality; however, this article... KB#267982. Keywords: Criteria, Dates, Arrays, Formulas, DSUM, DATEVALUE

 
85. How to Programmatically Select the Current Data Area Without Selecting the First Row In Microsoft Excel, you can create a Microsoft Visual Basic for Applications macro that selects the current data area without selecting the first... KB#213333. Keywords: AutoFilter, VBA, Macro, Web

 
86. Excel Filters -- AutoFilter Basics AutoFilter Basics Prepare the Database Filter the Database Remove a Filter Create a Custom Filter 1. Set up the database a) The first row (A1:G1) has headings. b) Subsequent rows contain data. c) There are no blank rows within the database. For a workbook with sample data, click here. d) There is a... Keywords: AutoFilter, Criteria, Sales, Printing

 
87. How to Count the Occurrences of a Number or Text in a Range This article explains how you can use worksheet functions in Excel 2000 and later to count the number of occurrences of a specific number or text string in a range of cells on a worksheet. The More Information" section of this article contains... KB#214153. Keywords: Wildcard, Arrays, Formulas, COUNTIF

 
88. Index Service Stops Responding When Filtering Japanese Excel File Indexing Services may loop infinitely when it tries to index certain Microsoft Office documents. Currently, the only case where this is found to occur is with a Japanese Microsoft Excel spreadsheet on the Japanese version of Windows 2000. No... KB#321073. Keywords: Query, Errors, File Name, Index Server, Web

 
89. How to Count Rows Displayed After Data Has Been Filtered This article contains a sample Microsoft Visual Basic for Applications Sub procedure (macro) that counts the number of rows that remain after you use AutoFilter or Advanced Filter on the Data menu to filter a... KB#213330. Keywords: Advanced Filter, AutoFilter, VBA, Macro, Web

 
90. MSQuery Uses 1900 Date When Two Digits Are Used for Year When you perform a query in Microsoft Query 97 for Windows, and you use two digits for a year in the criteria, Microsoft Query may return records that meet criteria other than the criteria you... KB#187698. Keywords: Criteria, Query, Dates, Years, Toolbar, Web

 
91. Cannot Derive Parameter Information When the Parameter Marker Is a Function Argument When you query a database on SQL Server 2000, you may receive the following error message: [Microsoft][ODBC SQL Server Driver]Unable to derive parameter information when parameter marker is a function argument When you click OK , you may receive... KB#821789. Keywords: Query, SQL, Errors, Registry

 
92. Cannot Disable ToolTips Directly from Microsoft Query You cannot disable ToolTips from within Microsoft Query. If you do not want ToolTips to be displayed, do the following according to the version of Microsoft Query you are using: Microsoft Query for Windows 95, version 2.0 WARNING: Using... KB#107254. Keywords: Query, Files, Registry

 
93. Help using Excel spreadsheet functions - Using Array formulae An array is simply a series of data, which in a spreadsheet is normally stored in a range of adjacent cells. Excel however can do special things with arrays that may be used as a flexible alternative to the database functions such as DSUM. Many functions such as SUM or MAX can be combined with the... Keywords: SERIES, Criteria, Query, Arrays, Errors, Formulas, DSUM, MAX, COUNTIF, VALUE

 
94. Office 2000 ODBC Driver Vulnerability Security Update In the course of producing the solution to the Office 97 ODBC Driver Vulnerability, Microsoft testing became aware of a separate vulnerability in the ODBC database driver that may affect Office 2000 users. This vulnerability is related to the... KB#240159. Keywords: Query, Download, VBA, Files, Web

 
95. Text to Columns using VBA Column A Company Name A PO BOX 1 NEWARK NJ 07101 Company Name B PO BOX 2 1400 SANS SOUCI PARKWAY WILKES-BARRE PA 18703 Company Name C PO BOX 3 CHICAGO IL 60694 Company Name D PO BOX 4 CLEARFIELD UT 84015 Company Name E PO BOX 5 OGDEN UT 84401 Company Name F PO BOX 6 BALTIMORE MD 21264-4351 When I... Keywords: Sorting, Format, Formulas, Macro, VBA, Web, ROW, DSUM

 
96. How to Select the Current Region Minus the First Row This article contains a sample Microsoft Visual Basic for Applications macro (Sub procedure) that selects the current data area without the top... KB#148462. Keywords: AutoFilter, VBA, Macro, Web

 
97. Excel: Converting Excel tables into XML files This section offers some simple guidance of how to transfer data between Excel, Access and HTML web pages using XML data files. VBA programs can be used to export data tables from Excel or Access into simple XML files. There are several examples of using different methods to display the XML and XSL... Keywords: Criteria, Data Table, Query, Sorting, Dates, Export, XML, Format, Symbol, Macro, VBA, Files, HTML, Internet Explorer, Web

 
98. How to use Advanced Filter to Exclude Records in Excel 2000 This step-by-step article explains how to use the ISNA and MATCH worksheet functions to exclude records in a Microsoft Excel database that do not match another list. How to Create Exclusion Criteria To create exclusion criteria, use the... KB#214324. Keywords: Advanced Filter, Criteria, Formulas, MATCH

 
99. How to use an Excel Worksheet as a Data Source in FrontPage 2000 This article describes how to use a Microsoft Excel worksheet as a data source in Microsoft FrontPage 2000. Use an Excel Worksheet as a Data Source in FrontPage To use an Excel worksheet as a data source in FrontPage, follow these steps: NOTE:... KB#268948. Keywords: Query, DAO, Files, Web

 
100. How to Avoid Saving Password in Text File When You Get External Data When you use a new database query to retrieve data from external sources into Microsoft Excel, you are asked to save the password twice. If you select either of the following check boxes Save my UserID and Password in the data source definition... KB#253300. Keywords: Query, Password, Registry, Text Files

 

<< (Page 1)  Previous              Next  (Page 3) >>