• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 15. Using Advanced Excel Databas... > Common Problems and Solutions

Common Problems and Solutions

Q1:Using the criteria range to filter data returns all the items in the database.
A1: Make sure there is not a blank line in the criteria range.
Q2:Subtotals appear at the top of my data instead of at the bottom of the list.
A2: In the Subtotals dialog box (which you access by choosing Data, Subtotals), check the Summary Below Data box to place subtotals at the bottom of each data range.
Q3:Original subtotals still appear after new subtotals are requested.
A3: When selecting a subtotal, check the Replace Current Subtotals check box to replace old subtotals with new ones.
Q4:When I enter a function, the function name appears in the cell, not the results of the function.
A4: Make sure you've started the function with an equals sign (=). If you don't use that sign, Excel reads the function as text.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint